Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
Partner - Creator
Partner - Creator

Convert timestamp to date

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.

rupaliqlik_0-1629866774805.png     

rupaliqlik_1-1629866968751.png

 

 

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

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

 

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

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
Partner - Creator
Partner - Creator
Author

Thanks,It works.

lironbaram
Partner - Master III
Partner - Master III

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

so other users can help where help is needed