Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
psenthilbtech
Contributor III
Contributor III

TimeStamp to Date Issue

Hi Team, 

I have a Timestamp field , 

When i try to  use Date function , i have multiple dates (duplicate) . Attached snapshot for reference. 

 

 

Regards,

SenCapture.PNG

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

You could use floor()to truncate the decimals from the timestamp to get rid of this issue. Try like:

Date(Floor(<yourRawTimestamp>))

 

View solution in original post

1 Reply
tresesco
MVP
MVP

You could use floor()to truncate the decimals from the timestamp to get rid of this issue. Try like:

Date(Floor(<yourRawTimestamp>))