Making the date from three numbers

[#1]

Hi All,

I have numbers for day, month, and year of a date: for example 28, 8, 2016 will be 28/8/2016. How should I get these into 28/8/2016 format in Qlik Sense?

Thanks!

[swuehl · Accepted solution]

Try

LOAD

     Makedate( year, month, day) as DateField,

     ...

in your load script.

edit:

and either set the default date format to 'D/M/YYYY' or use Date() function to format the date field:

LOAD

     Date(Makedate( year, month, day),'D/M/YYYY')  as DateField,

     ...

On Format Codes for Numbers and Dates

Get the Dates Right

Why don’t my dates work?

[Clever_Anjos]

MakeDate(2016,8,28)