Skip to main content

New to Qlik Sense

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

cancel
Showing results for 
Search instead for 
Did you mean: 
pankaj999
Contributor III
Contributor III

Convert Date to Month-Year format

I currently have converted date as this format :

ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30')

which gives me the date with a time stamp as  "21.2.2019 22:00:52", now I want to change this date to MonthYear to use in one of my graphs as a dimension in the set analysis itself.

Any idea how to do that?

 

Thanks

Pankaj

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Date(MonthStart(
ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30')
), 'MMM-YYYY')

View solution in original post

3 Replies
Channa
Specialist III
Specialist III

try to have below in script

 

ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30') as date_time

in report use below

date(date_time,'mm-yyyy')

Channa
sunny_talwar

May be try this

Date(MonthStart(
ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30')
), 'MMM-YYYY')
andrescc
Contributor III
Contributor III

Hi,

 

Try this:

=MonthName(ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30'))

 

Regards,

ACC