+44(0)1908738254
YOUR EXPERT RPA PARTNER

Team up with our RPA strategy and tech specialists for maximum automation impact

Find out more
Harness the power of UiPath in your business.
WATCH NOW

Save money and spend more time on priority work.

Book consultation
READY, SET, AUTOMATE

Let's choose, design and deploy a process automation solution for your business.

Find out more
TRANSFORM YOUR BUSINESS

Let's analyse your business to discover opportunities for innovation and automation.

Find out more

Begin your business transformation journey

Book consultation
AUTOMATE EVERY FUNCTION

Automate where it matters most. Scale to solve challenges in every area

Find out more
GIVE EVERY TEAM THE TOOLS FOR SUCCESS

Equip people with user-friendly solutions that save time and make work easier

Find out more

Which business problem
can we solve first?

Book consultation
30 September 2014

Negative and Positive numbers for K2 Appit Day Difference inline function

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.

 

Free K2 Five Upgrade Review

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.

Negative and Positive numbers for K2 Appit

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.

Need further technical advice or support?