Hi,
I need to do a few things in the one query and am not sure how the syntax goes...
heres what I want to do...
I have three dates
Lastdate, Now() and New Date.
- I want to cut the MM from LastDate - Left$(LastDate,2)
- Now I want to sub in this MM for the MM in todays date.
- And finally I want to test whether this new date (todays with the MM substituted in) is greater than todays date.
Is there a way of doing all this in the one query?
Thank you!
I need to do a few things in the one query and am not sure how the syntax goes...
heres what I want to do...
I have three dates
Lastdate, Now() and New Date.
- I want to cut the MM from LastDate - Left$(LastDate,2)
- Now I want to sub in this MM for the MM in todays date.
- And finally I want to test whether this new date (todays with the MM substituted in) is greater than todays date.
Is there a way of doing all this in the one query?
Thank you!