Calculate date fields, only if end date is captured... or....

Follow

Esti Brooks

• March 01, 2017 15:58

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?

 

0

• 

  Rainer Grabowski

  • March 11, 2017 09:58

  Hi,

  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 
  
  

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.