Calculate date fields, only if end date is captured... or....
I have two separate date fields, one for "First Inquiry" (this is the start), one for "Contract Acceptance" (this is the end date).
However; when Contract Acceptance is left blank the calculation field (see preview) defaults to "-16,679 days".
If I were to create an extra date field, which only reads today's date, is there a way to default to a "days so far" if the "Contract Acceptance" date is blank?
this would show 0 days until a date is entered in the field Contract Acceptance:
var first = moment(@First Inquiry);
var acc = moment(@Contract Acceptance);
acc != null ? acc.diff(first,"d") +1 : 0
For a "days so far" calculation that updates every new day you need an extra date field (in this app or in a related app) which is updated every day. How to do that I've described in some postings, e.g here
Please sign in to leave a comment.