Change Date Format

  • Thread starter Thread starter Charles Deng
  • Start date Start date
C

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
 
Charles said:
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
Click to expand...


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.
 
In addition to what the others have told you, if all you want is the date,
use the Date() function, not the Now() function.
 
Back
Top