Obtain day of the week from a calender.

P

Patrick

If I have a user select a date from the activeX calender, is there a way that
I can obtain a value from it that is the day of the week? It can be in
whatever form as long as it is just the day. This is access 97.
 
J

John Vinson

If I have a user select a date from the activeX calender, is there a way that
I can obtain a value from it that is the day of the week? It can be in
whatever form as long as it is just the day. This is access 97.
Click to expand...

For the day number (1 Sunday, 7 Saturday) use DatePart("w", [date
value]); for the weekday name, "Sunday" or "Tuesday", use

Format([date value], "dddd")

John W. Vinson[MVP]
 
Top