View Single Post
 
Old 03-12-2020, 08:10 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

OK. The formula for OnTime was faulty! Right one must be
Code:
=IF(AND([Delivered]=0,[DueDate]>TODAY()),"",AND([Delivered]>0,[Delivered]<=[DueDate]))
I.e. when:
1. Document is not delivered and due date is in future, then it is not late jet and OnTime field will be empty;
2. Document is not delivered and due date is today or earlier, then it is late or it is being late when not delivered immediately;
3. Document is delivered, and due date was later or equal than delivery date, then delivery was on time;
4. Document is delivered, but due date was earlier than delivery date, then delivery was late.
Reply With Quote