Days of the Year in number

[Anonymous]

Good afternoon, everybody,

I'm trying to put the day number of the year on my calendar table, but I can't make it. My idea is to create a column that establishes that, for example, January 1st is December 1st or December 31st is 365/366.

Thank you and greetings!

[Fowmy · Accepted solution]

@Alejandro-Glez

Add this as a new column in your calendar table, I guess you have a date field named [Date]

Days in the Year = 
DATEDIFF( DATE(YEAR([Date]),1,1),[Date],DAY)+1

________________________

If my answer was helpful, consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

Youtube Linkedin

[mwen90]

Hey @Fowmy  the above solution is great, but what if you wanted the day number to continue? 

So it was 366 for not return back to 1 when the new year started?

I'd love a running total of my day numbers of the span,

Thanks for the help