Convert Date to Month-Year format

[pankaj999]

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

[Channa]

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

[sunny_talwar · Accepted solution]

May be try this

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

[andrescc]

Hi,

Try this:

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

Regards,

ACC