My users want to see a full posting date timestamp from reports.
Is there a code for the am/pm literal that appears after date and time, such as "m".
Excellent question -- there doesn't appear to be a 'format parameter' for AM/PM in the CMOD 8.5 online help.
The conventions in the online documentation are extremely similar to UNIX date formatting, so you may be able to use them.
https://en.wikipedia.org/wiki/Date_%28Unix%29
Specifically:
%l (Percent-Lowercase-L) for 12-hour clock hour field.
%I (Percent-Captial-I) for a 12-hour clock with a leading zero.
%p (Percent-Lowercase-P) for uppercase AM/PM
%P (Percent-Capital-P) for lowercase am/pm.
(These two seem backwards, no?)
On my system, %p gives 'pm', and %P gives 'P' -- which could either be single-character PM, or maybe it doesn't recognize that code and simply prints the letter P.
Give it a try and let us know how it turns out.
-JD.
I have new reports with date time stamp having 12 hour hh:mm:ss plus am/pm format, and they want the accurate date. so accepting am/pm is required.
I can break into a date piece and a time piece, time as text with the am/pm.
good enough.