CIVTIME

Pass it the military time from a time stamp field and it returns the standard time.

Reporting Area(s):

Registrations, Accounting

Required Parameters:

1. 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

 

Related Topics