Round Timestamps

[SonPhan]

Hello Qlik-Experts,

i have a question, how can i do something like this:

If it the time is e.g. between half past eight and 9:00, the outcome should be 8:30. Depending on the time the respective hours should apply. 

Date	Time	Expected Solution
04.01.2021	08:39:52	10.02.2021 08:30:00
04.01.2021	08:40:48	04.01.2021 08:30:00
04.01.2021	08:54:05	04.01.2021 08:30:00
04.01.2021	09:00:51	04.01.2021 09:00:00
04.01.2021	09:20:20	04.01.2021 09:00:00
04.01.2021	09:29:17	04.01.2021 09:00:00
04.01.2021	09:30:38	04.01.2021 09:30:00
04.01.2021	09:50:13	04.01.2021 09:30:00
04.01.2021	09:55:03	04.01.2021 09:30:00

Best regards Son

[brunobertels · Accepted solution]

Hi 

Try 

Date &' '&round(Time,'00:30:00')

and may be force the format to timestamp like this 

Timestamp#(Date &' '&round(Time,'00:30:00'),'dd.mm.yyyy hh:mm:ss') 

[SonPhan]

Hello,

unfortunately the solution is wrong, the yellow marked lines must be 08:30 and 09:00

But thank you!

[SonPhan]

But i think floor(TIME, '00:30:00') should be the solution.

Many thanks to you!