Can anyone help me with this problem?
I am trying to put together an "IF" statement which says:
If the due date is< today's date = Late
If the due date is = today's date = Due
If the due date is less 2 days than today's date = AT RISK
Otherwise = Pending
The IF statement I tried to put together, is correct all the way up to "AT RISK". Can anyone tell me how to do 2 days less.
F4 = Due Date
F2 = Today's date
Your help would be greatly appreciated!!
Thanks!
This message was edited by christal on 2002-05-09 11:40
I am trying to put together an "IF" statement which says:
If the due date is< today's date = Late
If the due date is = today's date = Due
If the due date is less 2 days than today's date = AT RISK
Otherwise = Pending
The IF statement I tried to put together, is correct all the way up to "AT RISK". Can anyone tell me how to do 2 days less.
F4 = Due Date
F2 = Today's date
Your help would be greatly appreciated!!
Thanks!
This message was edited by christal on 2002-05-09 11:40