This content has been marked as final.
Show 8 replies
-
Re: Change Date Format to MM-YYYY in Qlik Sense
pradosh thakur Jan 4, 2018 2:49 AM (in response to Woon Han Yap)date(floor(alt(timestamp#(Open Date,'DD/MM/YYYY hh:mm),timestamp#(Open Date,'DD/MM/YYYY hh:mm:ss)),'MM-YYYY')
OR
TIMESTAMP(alt(timestamp#(Open Date,'DD/MM/YYYY hh:mm),timestamp#(Open Date,'DD/MM/YYYY hh:mm:ss)),'MM-YYYY')
-
Re: Change Date Format to MM-YYYY in Qlik Sense
Woon Han Yap Jan 4, 2018 11:03 PM (in response to pradosh thakur)Thank you Pradosh!
-
-
Re: Change Date Format to MM-YYYY in Qlik Sense
Anton Aks Jan 4, 2018 2:44 AM (in response to Woon Han Yap)-
Re: Change Date Format to MM-YYYY in Qlik Sense
Woon Han Yap Jan 4, 2018 11:03 PM (in response to Anton Aks)Thank you Anton!
-
-
Re: Change Date Format to MM-YYYY in Qlik Sense
Ivan Bozov Jan 4, 2018 2:46 AM (in response to Woon Han Yap)Hi! Try this line in the load script:
Timestamp(Timestamp#([Open Date], 'DD/MM/YY hh:mm:ss') ,'MM-YYYY') AS [Open Date]
-
Re: Change Date Format to MM-YYYY in Qlik Sense
Anton Aks Jan 4, 2018 2:49 AM (in response to Ivan Bozov)I think that will work. At first I did not pay attention to the date format
-
Re: Change Date Format to MM-YYYY in Qlik Sense
Woon Han Yap Jan 4, 2018 11:03 PM (in response to Ivan Bozov)Thank you Ivan!
-
Re: Change Date Format to MM-YYYY in Qlik Sense
Ivan Bozov Jan 5, 2018 2:49 AM (in response to Woon Han Yap)You are welcome!
-
-