AnsweredAssumed Answered

Case function

Question asked by MehrdadBastan on Sep 17, 2014
Latest reply on Sep 18, 2014 by MehrdadBastan


Case function


Hi Eveyone
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;"Due";
Shoot Date<Get(CurrentDate)-30;"Over Due")