Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    4

    Cool Unanswered: Day of year for current day

    Hy,

    I try to define the position of the current day in the year. (For example, today where are the 224th day of the year)
    Do somebody knows a function to do dis?

    Thanks a lot.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    DatePart("y",Date)
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    n/m

    slick solution.
    Last edited by Teddy; 07-23-04 at 11:01.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Jun 2004
    Posts
    4

    Thanks

    DatePart("y",Date) is a good solution!

  5. #5
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    Quote Originally Posted by pierre samyn
    DatePart("y",Date) is a good solution!
    I wish I had not opened this thread as I just found a use for DatePart("y",Date)

    Mike

Posting Permissions

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