How to display AM/PM from date/time field.

[stormtrooper]

Hi. I have a date time field formula that looks like this:
totext({DATE_TIME_DTM},"h:mm:ss&quot

The time that is contained in this field has the am/pm attached to it and that's what I want to display. So far, with the above formula, I get what I want, just the time but I also need to pick up the am/pm part as well.

Please advise, thanks.

 

[AndrewBaines]

Could you just convert it to a time instead, then change the formatting to 12 hour with AM/PM?
Andrew Baines
Chase International

 

[AndrewBaines]

Another thought, change format string in your toText function:

totext({DATE_TIME_DTM},"HH*mm*ss tt&quot
Andrew Baines
Chase International

 

[AndrewBaines]

Another thought, change format string in your toText function:

totext({DATE_TIME_DTM},"HH:mm:ss tt&quot
Andrew Baines
Chase International

 

[stormtrooper]

Thanks. I guess I didn't think it was that simple. Kind of in formula mode for the moment.