Change Date Format

[Charles Deng]

Good morning, everybody!

Now I have a question: Can I change date format on my
report?

On design page, I wrote
=Now()


This coding gives Day and Date, such as Friday, September
10, 2004

Is there any way I change the code to only show Date, like:

September 10, 2004

Any advice will be highly appreciated.

Charles

 

[Marshall Barton]

Now I have a question: Can I change date format on my
report?

On design page, I wrote
=Now()


This coding gives Day and Date, such as Friday, September
10, 2004

Is there any way I change the code to only show Date, like:

September 10, 2004

When you don't specify a format for a text box, it uses the
data type and Access/System settings. Since those setting
can be changed outside your application, it's better to
specify the Format property of each control in a
form/report. In your case, you can use:

mmmm d, yyyy

See Format Property in Help for all of the many formatting
codes.

 

[Douglas J. Steele]

In addition to what the others have told you, if all you want is the date,
use the Date() function, not the Now() function.