Hi all,

Dates always seem to be a problem....I am trying to get last months date, I know it should be easy but its just not working..

I use the date command to get the current date. I then want to be able to sort of take one month away and get the previous months.....

Here is the code I am using at the moment.

Code:
CurMon = Format(Date, "mmm")
LasMon = (Month(Date) - 1) & "\" & Day(Date) & "\" & Year(Date)
LasMon = Format(LasMon, "mmm")
It doesn't work. If I declare LasMon as a date I receive an error...

Anyone know the easiest way to do this....

Cheers for any help