Getting the day for a holiday

C

Craig

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
 
C

Craig

Thanks Karl!

KARL DEWEY said:
Use Format([YourDateField],"w")

--
KARL DEWEY
Build a little - Test a little


Craig said:
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
Click to expand...
Click to expand...
 
Top