Timestamp error

[capriconuser]

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?

[tresesco]

@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#(...))

[Vegar]

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 @tresesco are saying, your output is correct it is just not formated as you would like it to be, preferably to a timestamp().