I'm working on a survey and one of the fields that they want to autopopulate is the "Julian date" or the "Day of Year". Similar to the week-number function. Has anyone come across anything that I could try?
this formula will create a full Julian date
=TEXT(TODAY(),"yyyy")&TEXT((TODAY() -DATEVALUE("1/1/"&TEXT(TODAY(),"yy"))+1),"000")
However you may be better served by creating a LUT needing to accommodate for leap years
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
