Working with timestamp (Round minutes)

[qlikconsultant]

Hi,

I try to compare timestamps. But i need only the date (DD.MM.YYYY) and time (hour and minutes (HH:MM)). How can I get the time in a seperate value and the secounds rounded?

[Gysbert_Wassenaar · Accepted solution]

Try  time(frac(floor(Mydate,1/1440)),'hh:mm') as MyTime

[qlikconsultant]

It works but how should be the code for the date?

[Gysbert_Wassenaar]

date(MyDate,'DD.MM.YYYY') should be enough. If you want to get rid of the hours and minutes etc to keep only whole days use date(floor(MyDate),'DD.MM.YYYY')

[Anonymous]

Using floor() cuts off the fractions on the data level, and it can save a lot in the file size.

[squeakie_pig]

>>date(MyDate,'DD.MM.YYYY') should be enough. If you want to get rid of the hours and minutes etc to keep only whole days use date(floor(MyDate),'DD.MM.YYYY')

daystart(MyDate) is handy to get rid of the hours and minutes