Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,
...
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,
...
MakeDate(2016,8,28)