Date format in a report

W

Welshie

The date is formatted in my table in yyyy/mmm/dd. In one report I need to
run for another organization the format needs to be in dd/mmm/yyyy format.
How can I change the way it displays in the report? I do not want to change
it in the table as I generally want the format to be yyyy/mmm/dd.
 
D

Daniel Pineault

You can simply use either the format property for the control or you can use
the Format() if you need to set the format to something that doesn't already
exist.

Format([YourDataFieldName],"dd/mmm/yyyy")
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
J

John W. Vinson

The date is formatted in my table in yyyy/mmm/dd. In one report I need to
run for another organization the format needs to be in dd/mmm/yyyy format.
How can I change the way it displays in the report? I do not want to change
it in the table as I generally want the format to be yyyy/mmm/dd.

If the value is in fact stored in a Date/Time field, it's not actually stored
with ANY formatting. It's stored as a double float count of days and fractions
of a day since midnight, December 30, 1899; and you can display it with any
format you like, even several different formats at once!

On the Report set the Format property of the textbox containing the date to

"dd/mmm/yyyy"

On your other uses, keep the existing format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top