Dlookup Date range
Posted on 2013-12-06
I have just created a holiday request form, which has DateFrom and DateTo. Using Datediff I am able to create the total days. But obviously this does not take into account holidays and weekends.
I seem various post, which appear to be beyond me, so I have created a table (WorkingDates) of dates from today though to December 2020, excluding national holidays (UK) and weekends.
My intention is to have the datediff based on the Dlookup from the WorkDates table, which I am struggling to get to work.
As I am using SQl backend and Access frontend I was wondering if date format may be part of the issue. I am using UK date format in the form i.e. 06/12/2013
The data type in both the Holiday Request Table and Working Dates Table id Date.
Many Thanks in anticipation.