Format date+time into m/d/yyyy h:nn AM/PM (1 Viewer)

[TB11]

Hi. I need for format a date+time query field into m/d/yyyy h:nn AM/PM. The format of the property sheet does not hold, so I need to code in the format within the query field. I just can't figure out the syntax. Right now, the seconds are included, which I do not want.

The present results, with query field name expDateTime: 6/13/2021 5:01:00 PM
Wished results: 6/13/2021 5:01 PM

I don't know if this matters, but the field is a calculated field from a totals query that I am using in the current query.

Can anyone help?

Thanks.

 

[theDBguy]

Is this what you tried?

Format([ColumnName], "mm/dd/yyyy hh:nn AM/PM")

 

[TB11]

@theDBguy THANK YOU, That's exactly what I needed.

 

[theDBguy]

@theDBguy THANK YOU, That's exactly what I needed.

Hi. Glad to hear it worked for you. Good luck with your project.