Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kinjal1645
Creator
Creator

Year in Date coming incorrect

Hello,

I am unable to get year correct for TS column after converting column t_stamp:

Year_incorrect.GIF

Expression used for column TS is "=Date(t_stamp)"

Can someone help me this?

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be this

TimeStamp(MakeDate(1970) + (t_stamp/8640000))

View solution in original post

6 Replies
isingh30
Specialist
Specialist

Try like this -

floor(Date(t_stamp))


Please share sample application or data.


Thanks

kinjal1645
Creator
Creator
Author

Didn't work

isingh30
Specialist
Specialist

Please share data in excel or sample application.

Thanks

sunny_talwar

May be this

TimeStamp(MakeDate(1970) + (t_stamp/8640000))

kinjal1645
Creator
Creator
Author

It is giving dates as shown in tops rows of below screenshot, not sure if it correct

1.GIF

sunny_talwar

I guess what do you expect them to show? What is the expected date for 2113098475738?