So I am looking for way for the from to populate the date field (Appointment Date) to be today's plus 10 working days, and check if that date is a Bank holiday if so offer next working day after bank holiday is this possible?
Many Thanks but what i am looking for is for my form to provide a date 10 plus in the future and if that day falls on a holiday skip to next dateHere is a sample database I built that includes a holiday table and shows how to use the code.
Number, what have you tried so far? have you attempted it, or do you need someone to provide you with a complete solution?Many Thanks but what i am looking for is for my form to provide a date 10 plus in the future and if that day falls on a holiday skip to next date
Number, what have you tried so far? have you attempted it, or do you need someone to provide you with a complete solution?
well if u have some coding skills u can modify the function in that zip I uploaded for u to do that. And by the way isn't the argument "ww" referring to weeks not days? I believe if u want to add days u have to use "d" or "dd" in that arg don't u? But at any rate I won't able to help ya for another ur or 2 as im at an appointment but hopefully the other guys can chime in before then.So I have created a bank Holiday Table and can add 10 days to todays date using "DateAdd("ww",2,Date())" set as defualt in the appointmet date field, but ihave no idea how to then look at the holidays dates and skip it
So, it's OK to end on a weekend day? If so, just add 10 to the date using DateAdd() and check the result by looking into the holiday table. If it's a holiday, add 1 using DateAdd().a date 10 plus in the future and if that day falls on a holiday skip to next date