12-hr Format

[Flowers4Algernon]

Hi, I wanted to  convert time from my table to 12-hr format. I have used this formula and it works as expected.

REPLACE(SUBSTRING(CONVERT(VARCHAR,[@field:datefield], 131),12,18),'.0000000','')

May I ask if you guys have any more solutions to this? 

[Kurumi]

Your formula is great! Thanks for sharing. Hmm, you can try JavaScript in the DataPage as well?  
https://stackoverflow.com/questions/13898423/javascript-convert-24-hour-time-of-day-string-to-12-hour-time-with-am-pm-and-no
https://www.geeksforgeeks.org/convert-time-from-24-hour-clock-to-12-hour-clock-format/

[NiceDuck]

Case

when DatePart(hour,[@field: date]) > 12

then DateAdd(hour, -12, [@field:date]) + ' PM'

else [@field:date] + ' AM'

end


its a lot longer than what you have but oh well...