Calculate the Number of days

[dvannoy]

I have a query that calculates the number of days "something" took. in the query it's

Total Days: [thisfield] - [thisfield]

I want the query not to count saturday and sunday. in my criteria i tryed

Not Like 1 And Not Like 7

It doesnt seem to work. Can someone help me with the Criteria..

Thanks Alot DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[CosmoKramer]

check out this thread:

thread181-107041

 

[WingandaPrayer]

Also try this link.

http://www.athree.com/cgi-bin/discu...Searchpage=0&Limit=25&Old=allposts&Main=55248

There should be an attachment which will also remove holidays.

change the last line to
funWorkDaysDifference = (lngTotalDays - lngTotalHolidays) - 1

If not the first day will include the start date.
25/9/2001 to 28/9/2001 would = 4
changing the last line to the above
25/9/2001 to 28/9/2001 would = 3

HTH

David

 

[dvannoy]

Have you used this module?? it looks like the date fields have to start with dt?? how can i get around it?..when i use it in a query it returns all 0's.

Thanks DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[WingandaPrayer]

The line below is the one that shows up in the query.

funWorkDaysDifference («dtStartDay», «dtendday»)

Your start date field would go into dtStartDay
and your end date field would go into dtendday.

Does this help !!


David

p.s. have you created a holidays table.

 

[MichaelRed]

or (again) FAQ181-291 from right here at Tek-Tips.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[WingandaPrayer]

Michael,

is it this one

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=261&newpid=181&cfid=22038154&cftoken=58233496

David

 

[MichaelRed]

Yes. You have found it!!

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over