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...
Anonymous , Try like
if(hour([datetime])<9 , [datetime].date + time(9,0,0) , [datetime])
amitchandak
Super User
Super UserAnonymous , Try like
if(hour([datetime])<9 , [datetime].date + time(9,0,0) , [datetime])
Thank you so much, works like a charm