When I find myself stuck on a formula that I have used before but simply did not file nor memorize, I am able to search online and find what I need. Today I needed the Access/SQL syntax for returning the first day of the current month. After about 3 clicks, I made it to this site and got my answer. Copy, paste, done. Thanks Rabbit (and Google)!
excerpt:
Re: Function to Return 1st of Month
This will return the first day of the current month of the current year.
Code: ( text )
CDate(Month(Date()) & “/1/” & Year(Date()))
That’s
CDate(Month(Date()) & “/1/” & Year(Date()))