Glauber Oliveira Posted January 24, 2019 Share Posted January 24, 2019 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 Link to comment Share on other sites More sharing options...
pascal bijwaard 3 Posted January 24, 2019 Share Posted January 24, 2019 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now