Diamond-Leopard
Registered User.
- Local time
- Today, 22:18
- Joined
- Oct 30, 2018
- Messages
- 26
Hello Again My Wonderful Friends.... Here is todays problem
I have a field named "Date Ordered" and I have another field named "Date Delivered" and what I would like is a calculated field called "Working Days Taken To Deliver"
So as the name suggests I am looking an expression that I can pop in the calculated field and it will look at the two dates and work out how many working days (Mon-Fri) it has taken to arrive. Not including the date of order.
So if ordered on Friday the 3rd and Delievered on Tuesday 7th then the Working Days would be the Monday and Tuesday so 2 2 Working Days
Thank you peeps, I know you'll smash it
I have a field named "Date Ordered" and I have another field named "Date Delivered" and what I would like is a calculated field called "Working Days Taken To Deliver"
So as the name suggests I am looking an expression that I can pop in the calculated field and it will look at the two dates and work out how many working days (Mon-Fri) it has taken to arrive. Not including the date of order.
So if ordered on Friday the 3rd and Delievered on Tuesday 7th then the Working Days would be the Monday and Tuesday so 2 2 Working Days
Thank you peeps, I know you'll smash it