Variable 'Yesterday at 21:00'

[EMME_DR]

Hi,

someone have some idea how can I create a variabile in the script that can extract the table's datas before the 21:00 about yesterday?

example:
today = 02/10/2023
result variable = 01/10/2023 21:00:00

regards,

M.

[rwunderlich · Accepted solution]

I think:

LET vX = TimeStamp(Today(1)-1) + MakeTime(21))

-Rob