Please let me know if this Date is Correct or Not?

[hello101]

If (DatePart("w", Date1) = 1

That means of the Day is Sunday !

What about

If(DatePart("y", Date1) = 16 (Does this indicate that the day = Martin L King Day) ??

Thank you

 

[PHV]

If DatePart("y", Date1) = 16 then date1 is 16 january.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hello101]

Hi,

Tks for the help but there's an If statement!
I want to check in my module if a specific day is a business day or not. so if i have in a table a date such as 1/16/2006 and i write in my module

If DatePart("y", Date1) = 16 would it recognize that date as a holiday (for sure after the whole method is called from a query for example)

Tks

 

[PHV]

Create a holyday table and have a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886