Forum Discussion
MCFNeil
9 years agoQrew Captain
The duration from "Date Created" will not work, until the record has been saved. (Assuming your formula is correct)
YOu can however use an IF statement and combine it with the function "Now()" to visually display the duration, until the record is saved and [Date Created] has a value.
If would be something like;
If(IsNull([Record ID#]), [Start Date / Time Field] - Now(), [Start Date / Time Field] - [Date Created])
If you have more details I can give a more accurate formula, as I'm assuming you are going to have some field type conversions mixed in there somewhere.
YOu can however use an IF statement and combine it with the function "Now()" to visually display the duration, until the record is saved and [Date Created] has a value.
If would be something like;
If(IsNull([Record ID#]), [Start Date / Time Field] - Now(), [Start Date / Time Field] - [Date Created])
If you have more details I can give a more accurate formula, as I'm assuming you are going to have some field type conversions mixed in there somewhere.