day of year and days left in the year?

day of year and days left in the year?

Post by TmF0Z » Thu, 18 Nov 2004 03:32:02


How can you get the day of the year and the days LEFT in the year for a date?
I see how you can get Outlook to tell you the WEEK number, but what about
the day?
 
 
 

1. First Day Of Year AND Last Day Of Year

2. Creating adataset of the day, month, year of every day for next year

I want to incorporate an element into a resourcing program I am
writing that tells me how many mon thru fridays there are in any given
month in the future.

I will only ever need to know the next 12 months at any given time.
Obviously these vary due to the way w/e's fall and # of days in the
month.

Ideally I need an output dataset that gives me 365 rows giving day,
date, month, year for each day. Am assuing the starting point is the
today() function but not sure about the in between - any help out
there? am guessing its a macro thing?

thanks
Matt

3. convert day of year to numeric value format year+day in 4 digits

4. Number of Days Left In Year w/Auto Year Change

5. How to calculate days left in the year, days elapsed.

6. Converting year & day of year to mm/dd format

7. day of year/week of year script

8. can I sort database by year if the field contains day/month/year

9. DateTime with only Year and Day of Year

10. trying to get day/month/year froamt while user enters year onl

11. trying to get day/month/year froamt while user enters year only

12. Date syntax to show a year ago from current year and day

13. Convert Years to Years/Months/Days

14. Convert years to years and days

15. Convert day, month, year, and time to just year