Forum Discussion
MCFNeil
9 years agoQrew Captain
If you have some date field you want to compare it to you can use the date created compared to the [Date Field].
Keep in mind that [Date Created] is a date/time field, so you will need to convert it to date only before your do the arithmetic to find duration.
If you want to go from date created to today:
From this moment:
Hope this helps point you in the right direction.
Keep in mind that [Date Created] is a date/time field, so you will need to convert it to date only before your do the arithmetic to find duration.
[Key Date Field] - ToDate([Date Created]) = Duration
If you want to go from date created to today:
Today()-ToDate([Date Created])
From this moment:
Now()-[Date Created]
Hope this helps point you in the right direction.