Mar 07 2018 05:10 PM
I'm having an issue getting the employee leave tracker to recognize days left when it comes to any month on the 30th day. I'll place in sick leave from 1/30/18 to 1/30/18 and it will come up as '0' in the days field instead of '1'. It only does this for the 30th of every month. In addition it effects the calendar view as well since it doesn't count the day (but it does color it).
Mar 07 2018 08:14 PM
Update, it seems that it's only doing this on the 30th of certain months. Below is a snap shot of it.
Mar 07 2018 08:31 PM
SolutionFigured it out! This is the formula to use
=DATEDIF([@[Start Date]], [@[End Date]],"d")+1
Not the =date360 or whatever the template came with :) Yayyy!
Mar 07 2018 08:31 PM
SolutionFigured it out! This is the formula to use
=DATEDIF([@[Start Date]], [@[End Date]],"d")+1
Not the =date360 or whatever the template came with :) Yayyy!