Query criteria to get previous month's data not working
Posted on 2016-11-01
I have a date field in a table and would like to enter query criteria to display the previous month's data, but every date function I've tried yields no results, even though there definitely are records from the previous month. I suspect there's something wrong with the way the date is stored but don't know how to pin it down and resolve it.
The date is stored as a short date and is formatted to display as mm/dd/yy. Query criteria along the lines of: =DateAdd("m", -1, Date()), or =Month(Date()-1), or =Month((Now)-1)), and various permutations of DateSerial yields no records. I tried making a query with just the date field so I could try different date functions on it, but no luck.
Thanks in advance for any suggestions.