Getting the day for a holiday

[Guest]

I have set up a table for holidays such as memorial day, labor
day,thanksgiving day and the day after. It has the month, week and day these
holidays occur on in integer values. I need to get the day of the week out of
the date. For example: Day(10/8/2007) gives me 8 when I really need 2
because it's a Monday. The same thing happens when using WeekDay function.

Any good ideas out there?

TIA

 

[Guest]

You need the Weekday() function

 

[Guest]

Use Format([YourDateField],"w")

 

[Guest]

Thanks Karl!

Use Format([YourDateField],"w")

--
KARL DEWEY
Build a little - Test a little

I have set up a table for holidays such as memorial day, labor
day,thanksgiving day and the day after. It has the month, week and day these
holidays occur on in integer values. I need to get the day of the week out of
the date. For example: Day(10/8/2007) gives me 8 when I really need 2
because it's a Monday. The same thing happens when using WeekDay function.

Any good ideas out there?

TIA