topic Re: Timestamp error in QlikView

Timestamp error

capriconuser — Thu, 24 Dec 2020 05:29:17 GMT

i have this field

Timestamp#([Start Date],'DD-MM-YYYY hh:mm:ss') as StartDate,

when I use timestamp# I got date like this 44158.375 but in excel data is in correct format ..

any solution?

Re: Timestamp error

tresB — Thu, 24 Dec 2020 06:03:17 GMT

@capriconuser ,

If you are getting a number using timestamp#(), that means it is being read right and you just need to put a formatting function like date() or timestamp() around timestamp#(), like,

Timestamp(Timestamp#(...))

Re: Timestamp error

Vegar — Thu, 24 Dec 2020 06:48:41 GMT

A timestamp is a so called dual value consisting of both a numeric value and a string value.

Consider the timestamp 2020-12-24 07:39 . It will have the string value '2020-12-24 07:39 ' and a underlying numeric value that is 44189,31934 .

So as @tresB are saying, your output is correct it is just not formated as you would like it to be, preferably to a timestamp().