IF condition to run between specific time range

[EliGohar]

Hi,

I want to write an IF condition that will check if the current hour (when the script is running) is between 4:50 AM - 4:59 AM and If the condition is true then perform a couple of actions.

I tried this:

LET vNow= timestamp(Now(),'DD/MM/YYYY h:mm:ss') ;
LET vStartTime = timestamp(Today(),'DD/MM/YYYY 04:50:00');
LET vEndTime = timestamp(Today(),'DD/MM/YYYY 04:59:00');

IF vNow >= vStartTime and vNow <= vEndTime THEN

But it's always False.

Many thanks,

Eli.

[martinpohl · Accepted solution]

Hi,

take this

LET vNow= timestamp(Now(),'DD/MM/YYYY hh:mm:ss') ;
LET vStartTime = timestamp(Today(),'DD/MM/YYYY 04:50:00');
LET vEndTime = timestamp(Today(),'DD/MM/YYYY 04:59:00');

IF vNow >= '$(vStartTime)' and vNow <= '$(vEndTime)' THEN

Regards

[EliGohar]

@martinpohl I was close 🙂

Thanks mate!