Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
modernnonamad
Contributor II
Contributor II

Change Date Format to MM-YYYY in Qlik Sense

Good day to Qlik Expert,

I would like to change the below date format to MM-YYYY in Qlik Sense, so that I could use this for one of my Dimension.

Do you know how should I do this please? Thank you very much in advance. Cheers!

Open Date
3/1/2018 14:55
2/1/2018 16:23
29/12/17 16:43:21
29/12/17 13:32:56
26/12/17 10:59:12
25/12/17 17:07:13
22/12/17 16:03:16
22/12/17 01:36:59
21/12/17 15:46:16
21/12/17 13:33:12
21/12/17 09:14:25
8 Replies
pradosh_thakur
Master II
Master II

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')



Learning never stops.
antonaks
Creator II
Creator II

Hi!

Try use Date(DateField, 'MM-YYYY')

Ivan_Bozov
Luminary
Luminary

Hi! Try this line in the load script:


Timestamp(Timestamp#([Open Date], 'DD/MM/YY hh:mm:ss') ,'MM-YYYY') AS [Open Date]

antonaks
Creator II
Creator II

I think that will work. At first I did not pay attention to the date format

modernnonamad
Contributor II
Contributor II
Author

Thank you Ivan!

modernnonamad
Contributor II
Contributor II
Author

Thank you Pradosh!

modernnonamad
Contributor II
Contributor II
Author

Thank you Anton!

Ivan_Bozov
Luminary
Luminary

You are welcome!