G Guest Mar 4, 2005 #1 is there an easy way to get the first day of current month - also need to then subtract 3 months from that? thanks!
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 Mar 4, 2005 #2 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)
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)