How to change a currennt date time

[ranorga]

Dear Community:

I am trying to transform a current date and time to a date and time value rounded to the lower hour, that is: If the current date and time is 09/03/2021 10:42:13, in the app field it should be written 09/03/2021 10:00:00.
Some of you know how to do it. Thank you in advance for your help.

Regards.

[MultiTech]

Easiest way I’ve always done this is to build out the time manually and convert it into a temporal type.

DateTime(
  concatenate(
    Date(today()), 
    " ",
    hour(TimeNow() - "00:00:00"), 
    ":00:00"
  )
)

• Alternatively, replace instances of today() or timenow() with date/time columns.

[ranorga]

MultiTech_Visions:

auto> DateTime(> concatenate(> Date(today()), > " ",> hour(now()), > ":00:00"> )> )> >

Thanks a lot @MultiTech_Visions!!!
Just one detail. I had to make a little adjustment to the HOUR formula for it to work:
HOUR (TIMENOW () - “00:00:00”).
Thanks again!

[MultiTech]

Yup, my oversight: HOUR() needs a duration, not a time. (I’ve updated the original post)

• Good catch!
  

BTW happy cake day!!!

[ranorga]

Perfect. Thanks!