Create a simple date/time with a formula

[Anonymous]

Hello

I try to create a datetime based on a IF condition but i can't manage to do it. I would like to transform any datetime that starts after 09 AM to a datetime that starts at 09AM.

I guess it should be simple and i apologize for being so dull

This is the formula i am using :

Heure début corrigée = if(hour(Calendriers[Début]) < 9;DATEVALUE(year(Calendriers[Début]) & "/" & month(Calendriers[Début]) & "/" & day(Calendriers[Début]) & " 09:00:00");Calendriers[Début])

Problem is "29/05/2020 08h00" is transformed to "29/05/2020 00h00", not to "29/05/2020 09h00".

If anyone has time to help me, i would greatly appreciate it.

Best regards

[amitchandak · Accepted solution]

@Anonymous , Try like

if(hour([datetime])<9 , [datetime].date + time(9,0,0) , [datetime])

[Anonymous]

Thank you so much, works like a charm