AnsweredAssumed Answered

Nested If statements?

Question asked by GJBDJC on Oct 28, 2015
Latest reply on Oct 28, 2015 by jbrown

Hello all,

 

I'm trying to get a nested if statement to work:

If (Order Start Date > Get(CurrentDate); "0"; If (End Date - (Get(CurrentDate)) ≥ 0; "1"; "0")) Is the product running today?

If (Order Start Date > Get(CurrentDate); "0"; If (End Date - (Get ( CurrentDate) +1) ≥ 0; "1"; "0")) is the product running tomorrow?

 

Basically, return a "1" if the product is running today, based on a start date and an end date.

The (Order Start Date > Get(CurrentDate); "0" returns a zero for products with future start dates and

the If (End Date - (Get(CurrentDate)) ≥ 0; "1"; "0")) returns a 1 if the end date minus  today returns a non-negative number.

 

Seems simple, won't work?????

Outcomes