Warren Oyco · Jul 18, 2019

cache basics date conversion

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

example: 14JAN1991 to 19910114

0 405
Discussion (2)1
Log in or sign up to continue

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

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

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