I am trying to do something like...
WHERE Format([Created On],"yyyy-mm") < Date()
...to only return data that excludes the current month. My dates are individual mm/dd/yyyy dates, I use the Format approach to put them in a Monthly format, so they can be grouped by month. Since the current month is never complete, I only want the last complete month, which is always "Last month"
This statement seems to be doing nothing. I return September data whether I include the staement or not. I have tried several (over 10) ways of tweaking this, but can't get it to exclude current month data from the returns.
Can anyone tell me how to do this please?