Date count Confusion !!

[Monkeyboy126]

Hi all

I want to be able to count the number of days between two dates but not including weekend days.

Any ideas?

Many thanks

 

[Naith]

Have a look at this:

http://www.kenhamady.com/form01.html

Naith

 

[Reebo99]

Create a formula :

DateTimeVar StartDate := {Table1.StartDateField};
DateTimeVar EndDate := {Table1.EndDateField};
DateDiff("d",StartDate,EndDate) -
DateDiff("ww",StartDate,EndDate,crSaturday) -
DateDiff("ww",StartDate,EndDate,crSunday)

Let me know how you get on......

Reebo
Scotland (Sunny with a Smile)