topic Timestamp without seconds? in QlikView

Timestamp without seconds?

qlikconsultant — Tue, 15 Jan 2013 14:38:07 GMT

I need from a timestamp in a new atribute DD.MM.YYYY HH:MM.

For that i use:

date([mytimestamp])&' '&time(frac(floor([mytimestamp],1/1440)),'hh:mm') as timedatevalue

This skript works but if the time HH:MM:00 the he put the new value one minute before.

Example.: 16:50:00 ends as 16:49

Any idea how can i fix that or any sugestion how I can get DD.MM.YYYY HH:MM on an different way?

swuehl — Tue, 15 Jan 2013 14:48:11 GMT

Try

timestamp#( timestamp( mytimestamp, 'DD.MM.YYYY hh:mm'), 'DD.MM.YYYY hh:mm') as timedatevalue

Tue, 15 Jan 2013 14:54:37 GMT

Hi Markus,

maybe the the fraction 1/1440 is not as smooth as one would expext.

Please try Date#(Date(mytimestamp)&' '&Hour(mytimestamp)&':'& Minute(mytimestamp))

Hope it helps.

Grüße

Klaus

Tue, 15 Jan 2013 15:08:43 GMT

swuehlwas faster and has the better code snippet.