Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Oklahoma City, Oklahoma, USA
    Thanked 0 Times in 0 Posts

    Working with Dates (A2KSR1)

    I need to be able to determine the day of the week in Sun, Mon, Tue,... format. I can't find anything that gives the method of doing this. I need it in a query.
    I am trying to write a scheduling program and need to put the calendar by month across the top and calculate the day of the week to fill a array.

    Jail Admin Medical

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Working with Dates (A2KSR1)

    The "ddd" format will display a date as Sun, Mon, etc. You can either set the Format property of a date field in a table or query to ddd, or you can use the Format function:
    DOW: Format([MyDate],"ddd")
    If you set the Format property, the field will still be a date field that can be used in computations.
    If you use the Format function, the result is text, suitable for export, but you can't use it in computations any more.

Posting Permissions

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