Formatting a Date Field

[tcarriero]

I've struggled with this far too long. Sorry but I don't know the proper terminology to use.

I have a date field which will need to be broken up later so certificates can be made out. How do I format it so January 1, 2010 will remain 01/01/2010 and not 1/1/10?

[JudyJones]

You can create the following expression for this field in a query: Format(DateFieldName,"mm/dd/yyyy"). Replace DateFieldName with the name of your field.

[tcarriero]

Thank you so much.
I had tried the mm/dd/yyyy format but I was putting it in the TABLE!
This is perfect - thanks again.

[Mark L]

I've struggled with this far too long. Sorry but I don't know the proper terminology to use.

I have a date field which will need to be broken up later so certificates can be made out. How do I format it so January 1, 2010 will remain 01/01/2010 and not 1/1/10?

You need to have a better understanding of Date/Time fields. They are not stored in any particular format; as a matter of fact, today's date (July 7, 2010) is stored as 40366.0! You format it at the time you use it; usually in the Format property of a textbox control on a form or a report. So, January 1, 2010 can be displayed as "January 1, 2010", or "01/01/2010" or "1/1/10" as your whim changes.

[tcarriero]

Good to know - thank you.