Get first day of previous month in Access

[MikeDamone]

I'm looking for a way to return the first day of the previous month in Access without the time

So if today is 7/1/2010, I'm looking to return 6/1/2010. Does anyone know how to do this? Thanks!!

 

[traingamer]

Use DateDiff - there are many examples on this site, including thread701-1184170

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[Emtucifor]

DateSerial(Year(Date), Month(Date) - 1, 1)

 

[MikeDamone]

Thanks. That did it!

 

[traingamer]

DateDiff was the incorrect answer. I meant DateAdd, but the DateSerial answer is much simpler than what I was thinking. It even automatically returns 12/01/2009 for any date in January 2010.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[Emtucifor]

Yeah, dateserial tolerates out-of-range values for month and day and adjusts appropriately. Quite useful.