Date/Time Field to Text in Specific Format 1

[PavelJHH]

I want to translate a date/time field to a text field in a specific format. For example, 8/13/2007 10:38 a.m. will become 200708131038, format YYYYMMDDhhmm with hours in 24-hour clock format. I believe there is a FORMAT command which can be used in a query to accomplish this but don't remember the exact layout of the command.

Thanks for any help you can give.


Paul

 

[SgtJarrow]

You have answered you own question.... You can also always search in help.

Format(value, formatdesc)

so

Format(mydate, "yyyymmddhhnn")

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer