Daynumber to Date

Results 1 to 3 of 3

Thread: Daynumber to Date

  1. #1
    Janne Guest

    Default Daynumber to Date

    I wonder if anyone knows how to get the date from the number of the day : datepart("y",#1996-09-11#) returns 255. <BR>But I would like 255 to become the accurate date on this year<BR>

  2. #2
    Eddie Campbell Guest

    Default RE: Daynumber to Date

    If what you are asking is how to get the date from a value of 255, you can do it, but only if you know which year you are dealing with as the 255 value is simply the number of days since Jan 1st<BR><BR>MyDate = DateAdd("d",255,"01/01/01")<BR><BR>This would return 13th Sept 2001 as that is 255 days later than 1st of Jan

  3. #3
    janne Guest

    Default RE: Daynumber to Date

    Thanks for your answer, it will help solve a function in my calender<BR>janne<BR>

Posting Permissions

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