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?
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
Second I calculate the Day Difference between Today and the First of the Year
Finally I add 1 to it to take todays date into count.
How about it as a calculated column-
To get the number for the day of the year:
Then append the year to it to get the Julian format.
Retrieving data ...