cache basics date conversion

Primary tabs

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

example: 14JAN1991 to 19910114

  • 0
  • 0
  • 170
  • 1
  • 1

Answers

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