Need help setting up script with date range calculation in If statement.
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.