Date to Day of the Week

[NDD]

I have a date field in my table using short date (Assessment Date). I want to keep that and add a field in the table that converts that same date to a day of the week. I'm trying to use a calculated field in my table (AssessmentDay) and can't seem to get the expression right.

Can somebody help a slow learner please.

 

[NDD]

Solved. Thanks.
Expression>Assessment Date
and change the format to ddd

 

[SmallTomato]

AssessmentDay:Format([Assessment Date],"dddd") ?

 

[pr2-eugin]

You do not create a field in the table. When you need it you create a Query to display the Weekday name. Or use an unbound Control on the Form ! Do not store the information.

 

[NDD]

You do not create a field in the table. When you need it you create a Query to display the Weekday name. Or use an unbound Control on the Form ! Do not store the information.

Thanks. Why not?

 

[ypma]

You could also use "Small tomatoes" formula in the after update of the assessment date
#Private Sub assessesment date_AfterUpdate()
Me.Text93 = Format(assessment date.Value, "dddd")
End Sub #

Regards Ypma

 

[pr2-eugin]

Thanks. Why not?

Reason 1 : If you store calculated fields in the table, then you will have to write code as ypma has shown to make sure update is made, every time a value is changed.

Reason 2 : If in case, someone edits the table data directly then you would not have consistent data.

Reason 3 : This is just an unwanted storage space. As you would declare it as Text, it is going to take up a minimum of 25 chars.

In summary; unwanted coding, inconsistent data, waste of space.

 

[namliam]

Reason 4: Just listen to Paul, he knows his thing

Seriously, dont store dependant/calculatable data like this EVER!