date manipulation..get first of month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there an easy way to get the first day of current month - also need to
then subtract 3 months from that?
thanks!
 
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!

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

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