Add a day of week field to table

[YNWA]

Hi, I have a table with a date field. I want to add a Day of week field to that table.

Is it possible to do so in an update query or anything like that? So the day of the week updates based on the date?

ANy ideas?

Thanks
Will

 

[namliam]

Noooooooooooooooooooooooo

Day of week is a calculated value and should NEVER be stored in a table.
Instead simply calculate it from the date on the fly in a query !

 

[YNWA]

How do I do that?

 

[Galaxiom]

Do not add a day of the week field. It is a derived value that should be calculated as required using the WeekdayName and Weekday functions.

WeekdayName(Weekday(yourdatefield))

 

[namliam]

Erm GAH, what is wrong with
format(date(), "DDDD")

or
format(date(), "DDD")

which is way more flexible and intuative to use IMHO?

 

[Galaxiom]

Of course. Doh.
Error #: C2H50H

 

[YNWA]

Erm GAH, what is wrong with
format(date(), "DDDD")

or
format(date(), "DDD")

which is way more flexible and intuative to use IMHO?

I'm confused.

Do I create a query? Do I put this code ^^^ in the Format part of the table field properties?

How do I go about it?

 

[namliam]

*

You make a query and make one of the fields be "dayofweek: format([Yourdatefield],"DDDD")"

 

[Galaxiom]

Don't put it in the table. It is a derived value.

Anywhere you need the day of the week from the date field in the table, such as in a query or a control on a form or report, use the expression.

In the query designer field cell:
TheDay: Format([yourdatefield], "dddd")

In the Control Source property of a control:
= Format([yourdatefield], "dddd")

 

[YNWA]

I get ya now, cheers.