How do I return YYYYMMDDHHMM

Question

Question

Tom Bruce · Mar 30, 2022

Hi, I’m using $ZDATETIME to return the following

I would like to return just the YYYYMMDDHHMM i.e. stripping out the seconds.

Does $ZDATETIME have an option for this?

Product version: IRIS 2022.1

Discussion (4)0

Log in or sign up to continue

Robert Cemper · Mar 30, 2022

you may try

USER>write $tr("abcdefghijkl","abcdxefxghxijxkl","2022-03-29T15:10:00+0100")

4 0

score 1 · Answer 1 · 2022-03-30T06:06:00-04:00

Hi,

You can use 8 for the date format part, but there is no time format parameter for HHMM.
Try with this line :

w $tr($ZDATETIME($zdth($zstrip("2022-03-29T15:10:00+0100","<>W"), 3,5),8,2)," :","")

score 1 · Answer 2 · 2022-03-30T06:26:54-04:00

Hi,

Try below command, this will give you the output in YYYYMMDDHHMM format.

w $extract($tr($zstrip("2022-03-29T15:10:00+0100","*p"),"TZ", ""),1,12)

Thanks,

Anusri

score 0 · Answer 3 · 2022-03-30T06:41:20-04:00

Lorenzo Scalese · Mar 30, 2022

@Tom Bruce
This solution is the most optimized I think.

0 0