AnsweredAssumed Answered

Need help setting up script with date range calculation in If statement.

Question asked by outsidethebox on Feb 7, 2012
Latest reply on Feb 7, 2012 by philmodjunk

Title

Need help setting up script with date range calculation in If statement.

Post

Hello,

 

I'm trying to set up an "If" statement within a new script, but I can't seem to specify the correct format in the calculation box.

This is what I am trying to specify as calculation for "If" statement:

Payment Entry::Auto Payment Date1  ≥ Projected Income::Beginning Date and  ≤ Projected Income::End Date

In this calculation criteria, I am trying to test the contents of field "Auto Payment Date1" to see if this date falls within the range of "Beginning Date" and "End Date".   The calculation field does not seem to like this syntax, plus I'm not really sure that this is the correct way to find a specific date within a range of dates within the calculation box.  But I do need to accomplish this within the "If" statement of the script.

 

Can anyone assist me on this?  It would be appreciated!

Outcomes