M
Matt
Is there a way for the Diff2Dates function to exclude weekends and holidays
in its calculation of the Difference between to General Dates?
For Example:
A field in my reporthas the following control source:
=Diff2Dates("dhn",[DateRcvd],[DateDue],True)
Where DateRcvd= 7/14/2008 08:00am and DateDue=7/21/2008 2:00pm
Right now the Diff2Dates function returns 7days 6hrs 0mins, and it should
return 5days 6hrs 0mins.
What code should be entered in my module to do this? I understand I will
probably have to build a table called tbl_Holidays with a HolidayDate Field.
in its calculation of the Difference between to General Dates?
For Example:
A field in my reporthas the following control source:
=Diff2Dates("dhn",[DateRcvd],[DateDue],True)
Where DateRcvd= 7/14/2008 08:00am and DateDue=7/21/2008 2:00pm
Right now the Diff2Dates function returns 7days 6hrs 0mins, and it should
return 5days 6hrs 0mins.
What code should be entered in my module to do this? I understand I will
probably have to build a table called tbl_Holidays with a HolidayDate Field.