I am just starting work on a couple of calculation fields. I am really new at this
.Attached is my layout. Here is a description of the calculations, one is fairly simple, the second one is a mind bender for me, anyway...
1: The Lead time field, which will be the PartDueDate minus the DateSubmitted
2: The PartStatus field which has one of four results, each with a different colour...
- If DateCompleted is blank and DueDate is not passed then PartStatus will be InProcess
- If DateCompleted is blank and DueDate is passed then PartStatus will be OverDue
- If DateCompleted has a date that is on or before DueDate then PartStatus will be Complete
- If DateCompleted has a date that is after DueDate then PartStatus will be CompletedLate
Any help as I make my way through this will be greatly appreciated as always...