Just wondering if anyone has a simple way to convert a date that a user selects into Julian date format.
I have a need to create a simple Batch Code using Jullian date format and the concatenated with some other values.
I have an Excel and Google Sheet formula that works but when trying to use it in Glide using the “Excel Code” functionality it doesn’t work.
I have also looked at the various date and time functions but can’t find a solution there either. I even tried formatting the date using luxon but I can’t seem to find the functionality there either!
My work around is to use a sheet instead and have the formula in there but I have noticed quite a delay in updating my application with the output. Because of this, I run the risk of a user recording the wrong Batch Code because the app has not updated in time.
Hence I would like to drop the sheet completely and have the functionality all within Glide Tables.
Just to be clear, are you looking for a true Julian Date, or just an Ordinal Date? (yyyyddd). I ask because people often refer to ordinal dates as julian dates.
If an Ordinal date will do, then the following will work in a Math column: