calculating day of week from a date?

[Phideaux]

i need to calculate the day of the week (Monday, Tuesday and so on) from the calendar date. how can I do it and have it displayed on a form in a field?

thanks for the help in advance!

Phideaux

The mind is the best toy.
Play with someone else's often

 

[Phideaux]

I forgot to mention it's Access 2000 that I'm using

The mind is the best toy.
Play with someone else's often

 

[istari88]

These give the day of the week: format(weekday(),"dddd&quot



test: Format(Weekday([testdate]),"dddd&quot