Convert timestamp to date

[rupaliqlik]

Hi Folks,

I want to convert below Date timestamp in 'YYYY/MM' format.When I wrote Date(floor(year_month_date),'YYYY/MM') as YR, it gives me wrong date.I just want only single value like 2021/08.

     

[lironbaram · Accepted solution]

If you want to see only one  value for all the dates in the month
use this expression:

Date(monthstart(year_month_date)0,'YYYY/MM')

[rupaliqlik]

Thanks,It works.

[lironbaram]

Hi, 
great , can you please mark the answer as correct, 

so other users can help where help is needed