How to construct a DateTime value?

[Joseph_Seddik]

Hello,

I have separate [Date] and [Time] values. I need to know please the way to join them together in a DateTime value, in order to use it in a Yes/No expression like:

NOW() > [DateTime]

I need to launch an action after a specific hour on a certain date, so I’m currently using:

OR(
  TODAY() > [Date],
  AND(
    TODAY() = [Date],
    TIMENOW() > "11:00"
  )
)

Which could simply be reduced to: NOW() > [DateTime]

Thanks!

[Marc_Dillon · Accepted solution]

Date + Duration = DateTime

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

[Joseph_Seddik]

I used:

NOW() > [Date] + (“11:00:00” - “00:00:00”)

And seems working. Thank you @Marc_Dillon

[Marc_Dillon]

KJS:

NOW() > [Date] + (“11:00:00” - “00:00:00”)

NOW() > [Date] + “011:00:00”

should work the same