Date and Time to text

[Guest]

I am running a query to select specific data for export to a customer. They
require comma delimited format.

How do I change a date to a text? example:

10/2/2006 to "20061002"

Also Time to military text? example:

5:20PM to "1720"

Thanks

 

[Guest]

You would use the Format function.
For example:

Format("2006/12/31 12:30","yyyymmddhhmm")

would yield 200612311230

If you want just the time then it would be just "hhmm" as the second
parameter.

 

[Guest]

Use Format([YourFieldName], "yyyymmdd")
For time use Format([YourFieldName], "hhnn")

"m" is for month but "n" is for minutes.