H
Hong
Hello,
I am tracking the response from suppliers, the status is: "On time" or
"Late".
[D3Date] is I received the response from suppliers.
=IIf([D3Date] Is Null,IIf(Now()-[issueDate]>1,"Late","
"),IIf([D3Date]-[IssueDate]>1,"Late","On Time"))
When I issue a ticket, shold be reponse in the following work date, if not
is "Late",
But if I issue on Friday, then the following work date is Monday, then the
expression doesn't work right, how can I avoid the Staturday and Sunday.
Thank you!
I am tracking the response from suppliers, the status is: "On time" or
"Late".
[D3Date] is I received the response from suppliers.
=IIf([D3Date] Is Null,IIf(Now()-[issueDate]>1,"Late","
"),IIf([D3Date]-[IssueDate]>1,"Late","On Time"))
When I issue a ticket, shold be reponse in the following work date, if not
is "Late",
But if I issue on Friday, then the following work date is Monday, then the
expression doesn't work right, how can I avoid the Staturday and Sunday.
Thank you!