topic Re: Convert timestamp to date in QlikView

Convert timestamp to date

rupaliqlik — Wed, 25 Aug 2021 05:01:09 GMT

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.

Re: Convert timestamp to date

lironbaram — Wed, 25 Aug 2021 05:34:43 GMT

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

Re: Convert timestamp to date

rupaliqlik — Wed, 25 Aug 2021 05:37:21 GMT

Thanks,It works.

Re: Convert timestamp to date

lironbaram — Thu, 26 Aug 2021 05:47:50 GMT

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

so other users can help where help is needed