topic Re: How to create a timestamp in QlikView

How to create a timestamp

Dayna — Tue, 27 Feb 2018 13:03:24 GMT

Hi All,

Completely stupid question, which is likely why I can't see an obvious answer on here, but how do you make a timestamp field?

I have a date, and a time, and I'd like it to be formatted like 'DD/MM/YYYY hh:mm:ss'

I've tried timestamp(Date&' '&Time,'DD/MM/YYYY hh:mm:ss') with no success. I know this is really simple, so sorry for the stupid question!

Kind Regards,

Dayna

sunny_talwar — Tue, 27 Feb 2018 13:08:47 GMT

Try like this

TimeStamp(Time + Date, 'DD/MM/YYYY hh:mm:ss')

YoussefBelloum — Tue, 27 Feb 2018 13:10:19 GMT

Hi,

you should use Timestamp# before Timestamp to interpret your fields like a Timestamp, like this:

Timestamp(Timestamp#(your_date_field&your_hour_field, 'DD/MM/YY hh:mm:ss'))

Dayna — Tue, 27 Feb 2018 13:15:13 GMT

Perfect! Thanks All!

YoussefBelloum — Tue, 27 Feb 2018 13:19:35 GMT

don't we need to use the Timestamp#() function when we want to evaluate non Timestamp field(s) as a Timestamp ?

Or it is just another trick you used here ?

sunny_talwar — Tue, 27 Feb 2018 13:26:23 GMT

Since both Date and Time have an underlying numeric value, all you need to combine them is to add them together using a plus sign

YoussefBelloum — Tue, 27 Feb 2018 13:32:18 GMT

Ok, thanks

ritaaguiar — Fri, 15 Feb 2019 16:55:52 GMT

Following this question, this may seem even more stupid but

where do you write TimeStamp(Time + Date, 'DD/MM/YYYY hh:mm:ss') ?

Is it on the data load manager?