Topic: count week and weekend days Posted: 03 Sep 2015 at 10:46am
How am I going to count the days exclude weekend
Example 1
DateOrd = 08/03/2015
DateCom = 08/10/2015
Days completed should be 5 not 7
Example 2
DateOrd = 08/03/2015
DateCom = 08/07/2015
Days completed should be 4
Thank you very much Praveen. Appreciated your help!
It worked exactly what I needed once I removed the bracket from Sat and Sunday
Local DateTimeVar d1 := {Orders.Order Date};
Local DateTimeVar d2 := {Orders.Ship Date};
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum