Date to Day of Week

[detgharris]

I have a Table with a Date field. The next field is "Day of Week". I'm sure this is a basic question, but I have been beating my head against the wall. How do I get the "Day of Week" field to automatically populate when I enter the "Date" in it's field.

 

[PWise]

Why whould need to do this run a query

Select mydatfield ,format(mydatfield ,"dddd") as dayofweek
from tablename