Calculating lapsed time between two dates

[scott]

Hi Ryan,

Here's a thread showing how to subtract two dates:

Subtract Dates from each other

Quick update to this popular old thread. This use case is now much easier to do, like in the example below: Start Date: {formdate: YYYY-MM-DD; name=start} End Date: {formdate: YYYY-MM-DD; name=end} {days=datetimediff(start, end, "D");trim=right} Difference is {=days} days I have used the datetimediff function and formdate command.

It uses "days" but you could use other time units like hours (use "h" instead of "D") or minutes (use "m" instead of "D").