Return number of days in a year

[cireost]

Hi - is there an easy expression to return the number of days in any given year?  So if input is 5/2/2018 - I would like 365 days returned.  Because of leap years, I want to make sure I get 366 days returned if a date falls within a leap year.

Thanks!

[Thableaus · Accepted solution]

Hi @cireost 

You could use this -

Create the field of Year

DateTimeYear([Date])

Calculate the Days of that Year

DateTimeDiff([Year]+'-12-31',[Year]+'-01-01', 'days') + 1

Cheers,

[Thableaus]

Have no idea why these 12-31 keep showing up.

But instead of those, you may need to reference 12-31 and 01-01, end and beginning of the year.

Cheers,

[danilang · Accepted solution]

@Thableaus 

Maybe we have to play "guess the offending word"

DateTimeDiff([Year]+'-12-31',[Year]+'-01-01', 'days') + 1

Edit:  It worked for me

Dan

[PhilipMannering]

Here's a fun alternative,

wf

[RameshKumarKanagaraj]

The below sample is the one I have used for my Workflow logic. Hope this is useful.