S
Sandy
Hello -
I have a field in a query
ExpDate: Format([ccExpMonth] & "/" & ([CCExpYear]+2000),"Short Date")
Where ccExpMonth and CCExpYear are integers so I had to combine two fields
into one and and convert to date format.
I want to find all records where ExpDate is less than 90 days from today.
I have tried the following in the ExpDate Criteria with no luck:
<=Now()+90
<=Date()+90
Thanks for your help!
sandy
I have a field in a query
ExpDate: Format([ccExpMonth] & "/" & ([CCExpYear]+2000),"Short Date")
Where ccExpMonth and CCExpYear are integers so I had to combine two fields
into one and and convert to date format.
I want to find all records where ExpDate is less than 90 days from today.
I have tried the following in the ExpDate Criteria with no luck:
<=Now()+90
<=Date()+90
Thanks for your help!
sandy