Formatting a date in a macro
 

lastmonth = Format(DateSerial(year(now()),Month(now())-1,1),"mmm")

LastMonth = lastmonth =
Format(DateSerial(year(now()),Month(now())-1,1),"mmmyy")

--
Regards,
Tom Ogilvy

"Tony" wrote in message
...
I created a macro for a report I do at work and it works great, but I am
trying to set a variable for the date. I use a line like < Lastmonth =
Month(now()) -1 and it shows the number "8" for August which is
correct.
The problem is when I try to format it to say "Aug". I used < Lastmonth =
Format (Month(now()) -1, "mmm") and the output I get is "Jan". Ideally
I
need the year also but I tried < Lastmonth = Format (Month(now()) -1,
"mmmyy") and the output is "Jan00". If anyone has any suggestions I would
really appreciate it. Thank you.