CIVTIME
Pass it the military time from a time stamp field and it returns the standard time.
Reporting Area(s)
Registrations, Accounting
Required Parameters
- TimeField (i.e. Cocrsetm,Nmuptm,Pyuptm,Rgupdttm)
--OR-- Character String in Time Format (i.e. "13:30:01").
Optional Parameters
None
Example(s)
CIVTIME(rgupdttm) returns 1:30 p.m. where rgupddttm = 13:30:01