Unusual date format

[Nomad0803]

I'm trying to display a date that is 1 month prior to the current date - i.e., today's date is 3/21/2007 and I want to display 2/21/2007 in that format.

I tried DatePart("m",Now()) & DatePart("d",Now()) & DatePart("y",Now()), but the date displayed is 5/18/1988.

Thanks in advance,
Nomad0803

 

[Nomad0803]

I don't see a way to delete this post, so I'll just report that I've found a solution.