How to Calculate days of the week

[djclntn]

I have a Table which contains dates & daysof the week. Instead of typing in the day can/how I just type in the date & automatically have the "day" appearin the day field?



Any assistant would be appreciated!

[pbaldy]

I wouldn't store the day of the week. You can calculate it from the date, using Day(), DatePart(), Format(), WeekdayName(), etc, depending on what you want to see.

[djclntn]

I tried creating another field to display the day of the week -- accordingto the date.

I used a calculate (Date/Time) Data Type Field & tried this expression:

WeekdayName([Sunday],[Sun],[Sunday])

[pkstormy]

To get the day, I typically use: Format(Date(),"ddd") for Sun or Format(Date(),"dddd") for Sunday.

I agree with Paul though and that you probably don't need to store the day value in the table.

Unless you need it for a specific reason, the day can easily be shown using the above expression in a query or on a form (ie. Format([MyDateField],"ddd")