We use julian dates in our programing and need the the day of the year to access.
B Bill53 Apr 22, 2005 #1 We use julian dates in our programing and need the the day of the year to access.
D Douglas J. Steele Apr 22, 2005 #2 You can convert a date to day of the year using either DatePart("y", Date()) or Format(Date(), "y") The first one returns a number, the second returns a string.
You can convert a date to day of the year using either DatePart("y", Date()) or Format(Date(), "y") The first one returns a number, the second returns a string.
J John Vinson Apr 23, 2005 #3 We use julian dates in our programing and need the the day of the year to access. Click to expand... DatePart("y", [datefield]) will return a number 1-366 for the day of the year. Format([datefield], "yyyy") & Format(DatePart("y", [datefield]), "000") will return 2005120 for the 120th day of the year. John W. Vinson[MVP]
We use julian dates in our programing and need the the day of the year to access. Click to expand... DatePart("y", [datefield]) will return a number 1-366 for the day of the year. Format([datefield], "yyyy") & Format(DatePart("y", [datefield]), "000") will return 2005120 for the 120th day of the year. John W. Vinson[MVP]
