topic SET a Time to a Timestamp in QlikView

SET a Time to a Timestamp

Wed, 28 Mar 2012 16:11:29 GMT

Hi,

Do you know how to set a time, in the timestamp.

Ex: If a process entry date is: 26/03/2012 01h56.

A working day starts at 8h00, so I want to store the value 26/03/2012 08h00.

if(hour(entry_date) < 8, ??Set(entry_date, 8h00)??, entry_date) as entry_working_date

Do you know a simple way to do it?

Regards,

Gonçalo

SET a Time to a Timestamp

pover — Wed, 28 Mar 2012 17:58:01 GMT

There is a maketime() function so you could do something like

timestamp(floor(entry_date) + maketime(8))

The floor function is used to get rid of the time part of entry_date and then you add 8 hours to the entry_date. The timestamp() format function is needed to change the number to a timestamp format again.

Karl

SET a Time to a Timestamp

Wed, 28 Mar 2012 18:09:44 GMT

Tks Karl!