Dates & Days Fields

[djclntn]

I thought to have heard or seen where a Table containing Field 1-the days of the week & Field 2- the date & as you enter the date the day was automatically inserted in the day field. Is there a way (a formula) whereby when I enter a date in the date field the correspondent day of the week is automatically inserted vs. manually inserting the days along with dates?

[pbaldy]

The day can be derived from the date, so there's no reason to store it (normalization mistake to store a calculated value). Depending on your needs, you can use Day(), Weekday(), DatePart() and Format() to display day info related to the date.

[djclntn]

How & whre do I put, Day(), Weekday(), DatePart() and Format() in my TABLE? I don't understand.....?

[pbaldy]

I would not have it in the table. I'd use those functions on forms and reports when I wanted to display the day to the user.

[djclntn]

I don't understand why one wouldn't want a "Day" Field & a "Date" Field in a Table like in a daily tasks Table or in a daily music (Aritst) played Table?

As a time saver I thought maybe I could create a field called, "day" which would automatically enter te day of the week accoding to the Date enter in the "date" field.

[pbaldy]

The problem is that you then have to make sure you keep it updated any time you edit the date field. You can do it, but I wouldn't bother. I guess if you're using 2010 the new calculated field might be an option, though I've never used it.