cache basics date conversion

Question

Question

Warren Oyco · Jul 18, 2019

How can I convert date format ddmmmyyyy to yyyymmdd in cache?

example: 14JAN1991 to 19910114

Discussion (2)0

Log in or sign up to continue

Rod Dorman · Jul 18, 2019

Use $ZDATEH() to convert to internal $HOROLOG format, and $ZDATE() to convert to your desired format

WRITE $ZDATE($ZDATEH("14JAN1991",8),8)

0 0

score 0 · Answer 1 · 2019-07-18T12:56:25-04:00

Warren Oyco · Jul 18, 2019

Great ! this is working for me, Thanks for your help :)

0 0