Question
Warren Oyco · Jul 18, 2019

cache basics date conversion

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

example: 14JAN1991 to 19910114

00
1 0 2 302

Replies

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 :)