Extract Day of Year (DOY)?

Question & Answer
, , , , ,
1

I want the Days to be numbered by how they are for the entire year, instead of just extracting the day for the month, so like if today is June 28, 2024 (Day 180 out of 366)

2

Hi @Clayton_Barton, you can potentially use a calculated field like below to determine the day of year:

dateDiff(truncDate('YYYY',{<date>}),truncDate('DD',{<date>}),'DD')
3

Hi @Clayton_Barton,
It’s been awhile since we last heard from you. Did Kelsey’s solution work for your case or do you have any additional questions?

If we do not hear back within 3 business days, I’ll go ahead and mark as solved.

Thank you!

4

Hi @Clayton_Barton,
Since we have not heard back, I’ll go ahead and mark the solution. However if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!