Forum Discussion
Create a simple date/time with a formula
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
Anonymous , Try like
if(hour([datetime])<9 , [datetime].date + time(9,0,0) , [datetime])
2 Replies
Anonymous , Try like
if(hour([datetime])<9 , [datetime].date + time(9,0,0) , [datetime])