Once again I need your help in solving this simple problem that is driving me crazy.
I have a database that has one table, 7 fields in which I am trying to track the orders and ship dates from our clients (Schools).
The fields are
School (Text field), Shoot date (Date field), Date Entered (Date field), Due Date Warning (Calculation field)
Date received (Date field), Date Shipped (Date field), Ship Date Warning (Calculation field).
Every school has a Shoot day and they must return their orders to us 10 day after the shoot date. Therefore the warning filed to let us know if they are late sending the orders.
When we receive the orders we enter the Date in Date received
We have 30 day after the shoot date to return the orders. I am trying to keep a tab on when we get the orders and when we have to send them back a little warning signs like "Due" & "Over Due" for both.
This is what I have. Please help. Thanks
For Due Date Warning
If (not IsEmpty (Date Received);"";
Case(Shoot Date="";"";Shoot Date<Get (CurrentDate)-11;"Over Due"; Shoot Date< Get (CurrentDate)-10;"Due"))
For Ship Date Waning
Case(not IsEmpty(Date Shipped);"";
Shoot Date<Get(CurrentDate)-30;"Over Due")