Formula for simple Date calculation

[Glauber Oliveira]

Dear all, I just want to identify if the year of the date of my Date Column has 365 or 366 days. I have tried to use the function DateDiff beteween 01/01/2018 ans 12/31/2018, for example, but it does not work because this function seems to be used only with columns and not absolut values. Could someone help me

[pascal bijwaard 3]

DateDiff('day',date(Year([datecol]),1,1),Date(Year([datecol]),12,31))+1

This takes the year of your datecol and manually sets the month and day to Jan1 and Dec31. Add one at the end as the end date itself is not included in the count.