Results 1 to 5 of 5
  1. #1
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134

    Determine day number in a year

    Dear Gents,
    um trying to make a function that determine what is the day number of today from the all year days
    Say if the date is 10/1/2017 then this is 10th day from 365 days.



    Any help please.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Using the Format function, it is "y" - Format(datefield,"y")

  3. #3
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134
    I think you didn't understand me well

    Today Tuesday November 7, 2017 is Day 311 / 365

    Day of year is a number between 1 and 365 (January 1 is day 1).
    After today there are 54 days remaining in this year.

  4. #4
    Join Date
    Apr 2017
    Posts
    1,673
    =Date() - DateSerial(Year(Date()),1,0)

  5. #5
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134
    Quote Originally Posted by arvilaanemets View Post
    =date() - dateserial(year(date()),1,0)
    thank you it works !!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-16-2019, 08:36 AM
  2. Replies: 3
    Last Post: 12-24-2015, 02:48 PM
  3. Function to Determine Number of Workdays Error
    By McArthurGDM in forum Modules
    Replies: 3
    Last Post: 12-08-2014, 02:51 PM
  4. Replies: 11
    Last Post: 11-11-2014, 06:04 PM
  5. Replies: 1
    Last Post: 04-14-2014, 08:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums