Access function to return day of the week

Sometimes you need the actual day name of the date and not the numeric equivalent, the following function will do that for you:

Public Function MyWeekDayName(dteDate As Date) As String

   'Will return "Monday", "Tuesday", etc. based on the date supplied
   MyWeekDayName = WeekdayName(WeekDay(dteDate), False)

End Function

Example use in debugger window:

?MyWeekDayName(#10/19/2009#)

Monday

About

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

Posted in Access Help, VBA
2 comments on “Access function to return day of the week
  1. SimonG says:

    Almost, actually what comes back is a day out, when fed a date that should be a Monday, “Tuesday” is returned, a date occurring on a Thursday returns “Friday”, etc.

    • Juan Soto says:

      Hi Simon,

      The function works for me as advertised, could it be in your country the month and date is switched to dd/mm/yy? Here in the US it’s mm/dd/yy.

      Let me know
      Juan

Free email subscription

Enter your email address:


Facebook

Twitter

Blog Archives

ITImpact
%d bloggers like this: