Time function in a script

[Black_Hole]

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 · Accepted solution]

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

[tresesco · Accepted solution]

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]

Hello @Frank_Hartmann , @tresesco ,

The expression works without any issue.

Thank you for your quick and effective solution. 👍