Date Time Stamp

Various commands to manipulate date and time

DATE() returns the system date, compared to TODAY which returns T24 date (banking date).

Examples, if today is 15.10.2013 and banking date is 09.10.2013:

OCONV (DATE(), “D2”) gives 15 OCT 13

TODAY                         gives 20131009

OCONV(TIME(),’MTS’)   gives 09:30:17

TIMEDATE ()                gives 09:30:17 15 OCT 2013

Quick tip

when you need to feed the standard “DATE.TIME” field in a record, take these 3 lines:

DATE.STAMP = OCONV(DATE(), 'D4-')
TIME.STAMP = TIMEDATE()
DATE.TIME  = DATE.STAMP[9,2]:DATE.STAMP[1,2]:DATE.STAMP[4,2]:TIME.STAMP[1,2]:TIME.STAMP[4,2]

 

If today is Apr 11th, you’ll get in the record from T24:

      35. 1 DATE.TIME...... 11 APR 13 01:44

and in the record from Jbase:

      DATE.TIME.......... 1304110144