Formatting Long Date

[jw5107]

I have a field that I would like to re-format.

The value in the field shows: 01/01/2004 06:13:00 AM
It is date/time data type.

How can I get this to show: 1/1/04 6:13AM ???

Any suggestions?? Examples??

Thanks in advance!!
jw

 

[Golom]

Format(DateField, "m/d/yy h:nn AMPM")

 

[MichaelRed]

see the ubiquitous {F1} (aka H E L P Keywork "FORMAT".





MichaelRed

 

[jw5107]

Thank you. Simple oversight.
jw