Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

modernnonamad
New 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
Valued Contributor III

Re: Change Date Format to MM-YYYY in Qlik Sense

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



antonaks
Contributor II

Re: Change Date Format to MM-YYYY in Qlik Sense

Hi!

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

Ivan_Bozov
Valued Contributor

Re: Change Date Format to MM-YYYY in Qlik Sense

Hi! Try this line in the load script:


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

antonaks
Contributor II

Re: Change Date Format to MM-YYYY in Qlik Sense

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

modernnonamad
New Contributor II

Re: Change Date Format to MM-YYYY in Qlik Sense

Thank you Ivan!

modernnonamad
New Contributor II

Re: Change Date Format to MM-YYYY in Qlik Sense

Thank you Pradosh!

modernnonamad
New Contributor II

Re: Change Date Format to MM-YYYY in Qlik Sense

Thank you Anton!

Ivan_Bozov
Valued Contributor

Re: Change Date Format to MM-YYYY in Qlik Sense

You are welcome!