Year in Date coming incorrect

[kinjal1645]

Hello,

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

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

Can someone help me this?

Thanks

[isingh30]

Try like this -

floor(Date(t_stamp))

Please share sample application or data.

Thanks

[kinjal1645]

Didn't work

[isingh30]

Please share data in excel or sample application.

Thanks

[sunny_talwar · Accepted solution]

May be this

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

[kinjal1645]

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

[sunny_talwar]

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