Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
Date(MonthStart(
ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30')
), 'MMM-YYYY')
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')
May be try this
Date(MonthStart(
ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30')
), 'MMM-YYYY')
Hi,
Try this:
=MonthName(ConvertToLocalTime(timestamp((25569+(value+3600000)/(1000*24*3600))), 'GMT+05:30'))
Regards,
ACC