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.
DateTime(
concatenate(
Date(today()),
" ",
hour(TimeNow() - "00:00:00"),
":00:00"
)
)
today()
or timenow()
with date/time columns.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!
Yup, my oversight: HOUR()
needs a duration, not a time. (I’ve updated the original post)
Perfect. Thanks!
User | Count |
---|---|
44 | |
35 | |
24 | |
23 | |
15 |