Display Julian Date

419
0
07-25-2022 05:08 PM
MattWeeber
New Contributor

I can't seem to find a description of how to display Julian dates in S123.  I have a tag code field that I would like to auto populate.  Part of the field includes a five digit Julian date as a portion of the tag code.  This is an example of what I would like to display: WSC22206.UW1.  Where the "22206" is today's date, July 25th 2022. I found the formula below in a separate post, but I can't figure out how to get the digits to display.

    =TEXT((TODAY() -DATEVALUE("1/1/"&TEXT(TODAY(),"yy"))+1),"000") 

0 Replies