Using DatePart or DateAdd functions

[AnthonyJ20]

Hello, I have a question. Can either the DatePart or DateAdd functions be used to automatically get the first day of a previous month? For example, when the month rolls over from one to the next, as in the case of September to October, how can either of these functions be used to present the first day of September or whatever the previous month might be? Any thoughts or examples?

 

[PHV]

get the first day of a previous month
DateSerial(Year(Date()), Month(Date()) - 1, 1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AnthonyJ20]

It sure did!! Thanks, that's just what I was looking for.