Convert date to day of week

[316854]

I want a column to have the date and the column to the right of it to show the day of the week.



I'm a complete Access newbie.

I know how to do this in excel.

How do I do this in Access?

I'm not familiar with VBA.

[rzw0wr]

Are you talking about a table, Form,Query or a report.

This is untested.
WeekDayName(Weekday(date,FirstDayOfTheWeek),Abbrev iate,FirstDayOfTheWeek)


Dale

[316854]

table ddddddddddddddddddddddddd

[316854]

I'm not sure what this means:

This is untested.
WeekDayName(Weekday(date,FirstDayOfTheWeek),Abbrev iate,FirstDayOfTheWeek)

[June7]

Here are some examples of expressions that manipulate date value using intrinsic date/time functions. http://support.microsoft.com/kb/210604

Also http://www.alvechurchdata.co.uk/accdate.htm

[316854]

i didn't explain my request clearly enough.

in excel i use this:

=TEXT(A3, "ddd")

what's the equivalent of this in access?

This is what i'm looking for:
Sun
Mon
Tue
Wed
Thu
Fri
Sat

[JoeM]

in excel i use this:

=TEXT(A3, "ddd")

what's the equivalent of this in access?

FORMAT([DateField],"ddd")

[316854]

"The expression Format([DateField],"ddd") cannot be used in a calculated column."

[JoeM]

"The expression Format([DateField],"ddd") cannot be used in a calculated column."

Where are you trying to do this?

You should be able to use this formula in a calculated field (expression) in a Query, or on a Report, i.e.

DayofWeek: FORMAT([DateField],"ddd")

[316854]

Click to Add
Calculated Field
Date/Time
Paste into Expression Builder box
OK
"The expression Format([DateField],"ddd") cannot be used in a calculated column."

[JoeM]

Click to Add
Calculated Field
Date/Time
Paste into Expression Builder box
OK
"The expression Format([DateField],"ddd") cannot be used in a calculated column."

You need to substitute the actual name of your field where it says [DateField].

[316854]

The title of the column is "Date"

FORMAT([Date],"ddd")
"The expression Format([Date],"ddd") cannot be used in a calculated column."

FORMAT(Date,"ddd")
"The expression Format([Date],"ddd") cannot be used in a calculated column."

[JoeM]

You should NEVER use reserved words like "Date" as field names. It could confuse Access, as it could either mean the Function "Date" or the Field "Date".

I am guessing that you are using a newer version of Access, and are trying to add this on the Table level. In older versions of Access, this was not possible. It was not possible to do calculations on the Table level. The had to be done on the Query or Report level. Many experienced DB programmers (including myself) would advise you to continue this trend, and not try to perform any calculations right within the table itself.

[316854]

I started using Access only after subscribing to Office 2013.

How do I make a query or report to show the result of the expression?

[JoeM]

Wow, so you are really starting at the very beginning here with Access.

Creating simple Select Queries are one of the most fundamental and basic tasks to do in Access, and one of the main reasons to use Access.
Any introduction book will show you how to build simple queries in Access, as will many, many places on line (just do a Google Search on "create select query in Access").
Here is one link with an online tutorial: http://office.microsoft.com/en-us/tr...CTT=1&client=1

Once you see how to do that, check out "creating a calculated field or expression in an Access query".

On-line books and tutorials will do a much better job explaining it that I ever could, as they have the benefit of visual aids.