Using Format to set WeekDayName & MonthName

[RunTime91]

Greetings Experts ~

This is my first of what I'm sure will be many cries for help as I begin my transition from being an advanced Excel user (VBA; Forms; Pivots; Queries & Reports) to an Access novice.

I am using Access 2013 on Windows 8.1 w/8 gigs.

My book resources include:

Access 'All-in-One' for Dummies and,
Access 2013 Bible


So, with that out of the way here is my first (very easy) question.


I'm trying to use the Format field in table design view to set the WeekDayName & MonthName based on a date entered in another field.


The field name where the date is entered is titled: RequestDate
The field name where I want the WeekDayName is titled: RequestDay
The field name where I want the MonthName is titled: RequestMonth

My research suggested I input into the following into the respective table fields format field: "([RequestDate], "dddd")" or "([RequestDate], "mmmm")"

Neither of these work and upon exiting the Format field they are autocorrected to: "([RequestDate], dddd)" or "([RequestDate], mmmm)"

Any help would be greatly appreciated ~

[June7]

I've never seen that.

I think you need to use Format() function but calculated field in table will not recognize it. Construct a field in query with expression or calculate in textbox on form/report.

Format([RequestDate], "dddd")

[RunTime91]

I've never seen that.

I think you need to use Format() function but calculated field in table will not recognize it. Construct a field in query with expression or calculate in textbox on form/report.

Format([RequestDate], "dddd")

June - Thank You so much for the quick response - You have saved me a lot time trying to figure this out. I'll put your idea's to work in both queries & textboxes as you suggest.

Thank You again ~

This thread is resolved