Bringing QlikSense to handle a UNIX-Date format as date

[QlikSensor]

Hi,

I read data where one column is a date in UNIX format. It is handled as date in Excel as well. But if I read this into Qliksense, the date is only a string. How can I make Qliksense to recognize is as date?

[steeefan]

This support article should be helpful: How to convert Epoch Unix Timestamp.

[QlikSensor]

Thanks for this, I think I messed my OP up with leading you in the wrong direction. It is not UNIX format (I thought it be), but it looks like this:

2023-12-15T05:31:17.873799400

[steeefan · Accepted solution]

Timestamp(TS) AS TSConv should do the trick: