query any date before current month

camp1310

New member
Local time
Tomorrow, 02:50
Joined
Jul 12, 2013
Messages
1
Hi, I thought this might have been an easy one but i cant find any references to it.
I am trying to query any date before current month. My data is employee start dates, thus my end aim is to pick up all employees at end of last month.
Thanks
 
Code:
WHERE [datefield] < DateSerial(Year(Date()), Month(Date()), 1)
 
Last edited:

Users who are viewing this thread

Back
Top Bottom