date manipulation..get first of month

N

nycdon

is there an easy way to get the first day of current month - also need to
then subtract 3 months from that?
thanks!
 
R

Rick Brandt

nycdon said:
is there an easy way to get the first day of current month - also
need to then subtract 3 months from that?
thanks!
Click to expand...

FirstOfThisMonth: DateSerial(Year(Date()), Month(Date()), 1)

ThreeMonthsAgo: DateSerial(Year(Date()), Month(Date())-3, 1)
 
Top