Date Problem

[JJT]

How are you? I would like to change the format of a date on a report.

The current format is =NOW() which gives me 2/24/2004 9:10:58 AM

I want to change it to February 24, 2004.

What do I have to do to make the change?

Thanks

 

[Kraj]

All you should need to do is go to the control that has =Now() for the data source. The go to the Format tab and change/set Format to Long Date, or whichever date format matches what you want.

If it still spits the time out (although I don't think it will), change =Now() to =Date().

 

[Mile-O]

=Format(Now(), "mmmm dd, yyyy")

 

[JJT]

Thanks

For your help.