topic Re: Time function in a script in QlikView

Time function in a script

Black_Hole — Sat, 16 Nov 2024 18:47:32 GMT

Hello all,

I put in my script the following expression

SET vPeriod= Year(Today())&Month(Today());

I am expecting to have the result : 202004

Please could you help me to confirm if this expression gives the result above or not.

Many thanks in advance for your help.

Have a nice day !

Frank_Hartmann — Mon, 13 Apr 2020 09:35:01 GMT

Year(Today())&num(Month(Today()),'00')

tresB — Mon, 13 Apr 2020 09:39:35 GMT

Change your SET to LET, and then try like:

LET vPeriod= Year(Today())*100 + Month(Today());

Or like string operation shown above by Frank

Black_Hole — Mon, 13 Apr 2020 10:07:56 GMT

The expression works without any issue.

Thank you for your quick and effective solution. 👍