Calculating Working Day

[tnago]

Hi

I am trying to calculate number of day since a particular event. A user enters a date on which a an e-mail is received. Once that date has been entered, I like to automatically calculate the number of working days including holidays (which are in already defined in another table).

So basically it is comparison of two dates and then calculating number of workings and displaying them on the form. (The first date is populated when an event occurs and second date is entered when an e-mail notification regarding the event is received). The default value is zero.

Any help in this regard will be greatly appreciated.

 

[stardusty]

difference between dates

Check this link and see if it helps.

http://www.access-programmers.co.uk...adid=39034&highlight=difference+between+dates

 

[tnago]

Yes Me.txtdiff = DateDiff("d", [Date Entered], [Deadline]) will give me number of days between two dates, however there is still an issue of only showing working days i.e # of days minus weekends and any public holidays. Any suggestion?

Thanks

 

[Mile-O]

If you are in the UK then you can adapt the code I posted on this thread.

 

[tnago]

Thanks, however as I am not in UK I am unable to use the solution that you suggested. I have read other solutions that others as well yourself have posted on similar problems, but I still did not find any suggestion as to how to get number of week day minus holidays which are defined in separate table.

 

[Autoeng]

Try here.

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=261