dateadd help

[dubsdj]

Hi I'm trying to add 10 days to a value but I don't want to include weekends or holidays say between June the 15th and June the 20th are a holiday as an example.



DateAdd("d",+10,[Loan Date])

I cant seem to figure out the weekday feature and how I can also include between dates to ignore.

I want this in a query.

any help greatly appreciated thanks

[ssanfu]

Take a look at: Doing WorkDay Math in VBA

http://www.mvps.org/access/datetime/date0012.htm


There is a function named: Function dhCountWorkdaysA


It gives a count the business days (not counting weekends/holidays) in a given date range.

There are many useful date functions on this page.

[dubsdj]

Thanks

I am also trying to do this:

IIF (DateDIFFW([Due Date],[Return Date]) > 10, [Fine] + 1.00

which says if the result of the DateDIFFW module is greater than 10 then add 1.00

but i get a syntax error

[ssanfu]

The syntax for the IIF() function is

IIF(Condition, value if TRUE, Value if FALSE)

You are missing the FALSE part and the closing parenthesis.

Try:

IIF (DateDIFFW([Due Date],[Return Date]) > 10, [Fine] + 1.00, [Fine])

or

IIF (DateDIFFW([Due Date],[Return Date]) > 10, [Fine] + 1.00, "")