I need a Date Time Function to create a Integer Date in format YYYYMMDD?

[aritting]

I want to convert the current date to an integer value in the format YYYYMMDD.

For example, Today is 12/09/2016 in MM/DD/YYYY format and converted to YYYYMMDD is 20161209.

I would be using the today() or now() function as the source of the date.

Can any provide an example in how to do this in Qlik script?

[sunny_talwar · Accepted solution]

May be like this:

This is still date, but in the required format

LOAD Date(Today(), 'YYYYMMDD') as Date

or

This is a number now

Num#(Date(Today(), 'YYYYMMDD'), '##') as DateNumber

[aritting]

yes, that works in a Load statement and expression

Num#(Date(Today(), 'YYYYMMDD'), '##') as DateNumber

or

LET vL.MyVar = Num#(Date(Today(), 'YYYYMMDD'), '##');

[aritting]

Thank you very much!