topic Re: How do I use DayNumberofYear function to always return a 3 digit day in App Development

How do I use DayNumberofYear function to always return a 3 digit day

JayG — Mon, 19 May 2025 12:33:06 GMT

I am using DayNumberofYear(Orderdate) function to produce a Julian date based on the Orderdate field, with the year starting on Jan 1st. I need the function to return a 4 digit year followed by a 3 digit day (representing the # of days since January 1st). In cases where the day is less that 100 (which is April 10), the day displays as one or two digit numbers. I need it to always be a three digit numbers. In these cases, I need one or two leading zeros before the day, for example Jan 01, 2025 needs to display as "2025001" [but function returns "20251"], Apr 01, 2025 needs to display as "2025091" [but returns "202591"]. Apr 10, 2025 displays correctly because day 100 is three digits already so displays as "2025100". Anyone have any idea how I can do this?

Here is the script I am currently using in the Data Load Editor:

Year(Orderdate) & DayNumberOfYear(Orderdate) as Orderdate_Julian

Re: How do I use DayNumberofYear function to always return a 3 digit day

Clement15 — Mon, 19 May 2025 13:05:34 GMT

Hello,

This should meet your needs.

Year(Orderdate) & Right('000' & DayNumberOfYear(Orderdate), 3) as Orderdate_Julian

Re: How do I use DayNumberofYear function to always return a 3 digit day

paulwilli — Mon, 19 May 2025 13:53:51 GMT

try this:

Year(Orderdate) & Repeat(0,3- len(DayNumberOfYear(Orderdate))) & DayNumberOfYear(Orderdate)

Re: How do I use DayNumberofYear function to always return a 3 digit day

rwunderlich — Mon, 19 May 2025 14:05:42 GMT

Year(Orderdate) & Num(DayNumberOfYear(Orderdate), '000') as Orderdate_Julian

-Rob

Re: How do I use DayNumberofYear function to always return a 3 digit day

JayG — Mon, 19 May 2025 16:58:40 GMT

Worked like a charm! Thanks!!