AnsweredAssumed Answered

%IF Statement syntax

Question asked by DJCronin on Feb 20, 2018
Latest reply on Feb 23, 2018 by kirku01

Hi all,

 

I am trying to use the %IF statement in the 'Do not submit before" field, and I've had success with this before when using a simple equation like:

 

IF(today('1st workday of month'),'7pm')

 

But what I am trying to do is set the release time, depending on the time when the event triggered. I am receiving syntax errors, but with no real explanation as to what I have wrong.

 

I am using the following:

 

%IF((APPL._SHH > '17') && (APPL._SHH < '07')),'07:00'

 

My requirement is to set the wait time to 07:00 if the event triggers in between 17:00 and 07:00 the next morning.

 

Would love some suggestions if anyone has successfully coded this.

 

Thanks,

Denise

Outcomes