This seems to be a function that should be in a date library. I've been a programmer for 40 years and have worked with Julian Dates since 1977.
Does anyone know a quick way to find the day of the year?
This seems to be a function that should be in a date library. I've been a programmer for 40 years and have worked with Julian Dates since 1977.
Does anyone know a quick way to find the day of the year?
How about it as a calculated column-
To get the number for the day of the year:
=ROUNDDOWN(<YourDate>-DATE(YEAR(<YourDate>),1,0),0)
Then append the year to it to get the Julian format.
=TEXT(<yourDate>,"YYYY")&ROUNDDOWN(<YourDate>-DATE(YEAR(<YourDate>),1,0),0)
That won't work for what I need. I had to roll my own.
First I setup a variable for today. Next I set it to Today at Runtime.
Then I did two convert values: First) To use the year to get the Date of the Start of the year basically "01-01-yyyy
Payload Commanding
|
Second I calculate the Day Difference between Today and the First of the Year
Payload Commanding
|
Finally I add 1 to it to take todays date into count.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.