Hello everybody,
Is there a way to get the number of the day of the year?
Math column DAY (date) only gives the day of the month…
Thanks in advanced.
Albert
Hello everybody,
Is there a way to get the number of the day of the year?
Math column DAY (date) only gives the day of the month…
Thanks in advanced.
Albert
You might need it bookmarked. I’d use javascript column and get chatgpt to make it if anything beyound these
Try this.
Round(Date-
(((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)-DAY((Date+CEILING((YEAR(Date)-YEAR(Date))*365.2424)-DAY(Date)+15)-(MONTH(Date)-1)*30)+1))
It worked great. Many thanks!
Albert
You don’t need to complexity yourself. Just use the native Luxon format day of the year in the format Date computed column:
Today is feb 4th, so 31 days of January + 4 days of feb = 35!
Many of us are generally not in favor of using the Format Date column because it has a lot of compatibility issues with different devices and different regions. If it works it works, but I would do a heck of a lot more testing to verify the results from Format Date as compared to the Math column. Seen too many posts about unexpected results from using it.
Good to know! Thanks!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.