Negative and Positive numbers for K2 Appit Day Difference inline
The Day Difference K2 inline function calculates the number of days between two dates.
K2 Automated Testing Software
BenchQA allows full test automation of K2, including fully automated K2 SmartForms and K2 Workflow testing. It promotes test driven development for K2 and ensures continued quality assurance for K2 solutions. Easily apply changes to test cases to accommodate changes to K2 apps and ensure all apps are regression tested to avoid defects and assure continuous quality.
One observation here is that if you want to do an inclusive number of days, you need to add 1 to the result. The K2 expression editor can used to add 1 to the output of the day difference K2 inline function. This is the case for K2 blackpearl, K2 Appit and K2 blackpoint.
K2 Appit DateDiff – Inline Function
A final note. To get a positive figure for the days between two dates, the end date should be used as the first parameter. It makes sense, because if the dates are converted to offset in seconds for example, the end date will have a larger number and yield a positive figure if the start date is before it.