Calculate days between first and last transaction with Nexel

Document created by fcazzalini Employee on Apr 10, 2018Last modified by fcazzalini Employee on Apr 16, 2018
Version 2Show Document
  • View in full screen mode

About the Solution/Project: 

About the solution

Sometimes it becomes necessary to calculate how many days pass between the "first day" and the "last day" of something (project, invoicing..) even if not all the days are populated.

 

Solution/Project info

Info:

An example.

I worked for a specific "order" from 2nd April until 10th April, but I invoiced only 4 days; if I need to know how many days pass between the start and the end, I can not use a "write a 1 and count" solution.

With Nexel I can easily count what I need.

 

Attachments/Print Screens/Videos

Attached BOARD database and capsule.

Board 10.1.4 version

 

Takeaways/ Hints for other community Members:

Remember: if you need to store this information, you can use the Nexel WriteBack functionality.

1 person found this helpful

Outcomes