Select records based on a formula


#1

I can not figure out why this simple select formula is not working.

vInvoicePeriod variable has the value of “Aug-2017”

datepattern(DatePaidInFull,“Mon-YYYY”) = vInvoicePeriod


#2

You’re not giving us much to go on. What does “not working” mean? Error message? No data selected?

Where did you type this formula – into the Find/Select dialog?

If this is a procedure then where is the select statement?

In general this seems like a formula that should work, so there must be some other detail you are not mentioning that is the problem.


#3

Im sorry Jim,

I think Im tired, I just noticed it did not work because there was no data to match. It does work, Im the one that is generating errors. :slight_smile: