I have an order date and order sent date.
I have a report where I am calculating what is the time lapse between order date and order sent date.
My calculation simply says 'OrderSentDate' - 'OrderDate'. All works fine.
Now, this calculation also adds weekends days as well. Is there a way in way in FileMaker I can exclude the weekend. So time lapse would just be based on weekdays number.
How would my new calculation be like.