Hi!
I'm wondering if I can use a function in the criteria in QBE. This is what my QBE looks like now:
DatePart("m",[StartDate])
---------------------------------
---------------------------------
Where
---------------------------------
---------------------------------
9
I'm pulling the month out of the StartDate field and selecting on the value of 9.
What I want to do, instead of saying "9" is to say:
DateAdd("m",-1,Date())
(trying to get current month -1)
I can't seem to make it work though. I get nothing back in my datasheet.
Can this even be done? When I hardcode the 9 - I get the expected results.
Thanks!