Results 1 to 3 of 3

Thread: Day Of Week *SOLVED*

  1. #1

    Thread Starter
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Day Of Week *SOLVED*

    Is there a function similar to MonthName() to get the day of the week? I know there is WeekDay which returns a numeric number but i've already got the numeric number and I want to now get the day of the week. eg 1 would return Monday, 2 would return Tuesday.....
    Last edited by lintz; Dec 10th, 2003 at 11:03 PM.

  2. #2
    INXSIVE Bruce Fox's Avatar
    Join Date
    Sep 2001
    Location
    Melbourne, Australia
    Posts
    7,429
    Not sure with your region, however try (WeekDayName):
    VB Code:
    1. MsgBox WeekdayName(Weekday(Date, vbMonday))





    Bruce.

  3. #3

    Thread Starter
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697
    Thanks Bruce

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width