Weekday Name from a Date

[Coors]

I am relatively new to Microsoft Access, so I hope this question makes since. I am building a query and in one column it has a date span. When I run the query it returns the date ie. 5/03/2011. 5/03/2011 is a Tuesday. I want the next column in my query to say "Tuesday"

I have tired 'Expr1: WeekdayName(2)" to tell it the first day of the week is Monday, but then every day 5/03/2011, 4,5,6, 7th etc of May is Monday.


How do I write a formula so it returns the day of the week based on the date in another column.

Thanks,

[Coors]

Ok, I've tried this
Expr1: WeekdayName([Issue_Dt],False,2)
and when I run the query I get "#Func!" What am I doing incorrectly?

[RuralGuy]

Have you looked up WeekDayName() in help for the syntax?

WeekdayName(weekday, abbreviate, firstdayofweek)

The WeekdayName function syntax has these parts:

PartDescription

weekday Required. The numeric designation for the day of the week. Numeric value of each day depends on setting of the firstdayofweek setting.

abbreviate Optional. Boolean value that indicates if the weekday name is to be abbreviated. If omitted, the default is False, which means that the weekday name is not abbreviated.

firstdayofweek Optional. Numeric value indicating the first day of the week. See Settings section for values.

[Coors]

Have you looked up WeekDayName() in help for the syntax?

Yes, and thats how I came up with Expr1: WeekdayName([Issue_Dt],False,2)

Not sure what is wrong, I'm listing the columnn I want evaluated "Issue_Dt", Saying False, so no abreviation apprears, and stating "2" that Monday is the 1st day of the week.

[RuralGuy]

Except the 1st argument of the function needs to be a number from 1 to 7, not a date.

[Coors]

Except the 1st argument of the function needs to be a number from 1 to 7, not a date.

How does it know what date to look at if you don't tell it what column to pull from?

If I do Weekday([Issue_date],2) it returns the correct number, but when I do weekdayname([Issue_date],2) it won't.

[RuralGuy]

Try putting those two functions together:
WeekdayName(Weekday([Issue_date])).

[Coors]

Try putting those two functions together:
WeekdayName(Weekday([Issue_date])).

That worked!! Thanks.
I could get it to spit out numbers, but not the right day. Thanks for the help.

[RuralGuy]

You're welcome. Glad we could help. I marked the Threrad as Solved for you.

[boblarson]

And just as an alternative method (which is sometimes just as easy):

Format([Issue_date], "dddd") will yield the same thing.