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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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
tresB
Champion III
Champion III

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
tresB
Champion III
Champion III

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

Date(Floor(<yourRawTimestamp>))