Calculating Number of Days between two Dates
I have a Start Date {formdate: LL; name=sDatum}
and I have an End Date {formdate: LL; name=eDatum}
What is the Number of days in beetween?
scott
July 28, 2021, 1:32pm
2
Hi, and welcome to the forum!
Here is a post on just this topic!
To find the difference between dates, you want to use the {time: X} command which gives you the date in seconds.
Find the weeks from the selected date:
{formdate: YYYY-MM-DD; default=2020-09-30; name=date}
{ time: X} is the current date in seconds, { time: X; at={ =date}} is the selected date in seconds. We subtract one from the other to get the seconds between them.
We use "/ 60 / 60 / 24 / 7" to convert seconds into weeks.
Weeks to today from the selected date: {= ({time: X} - {time: X;…