DAYS Calculation

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › DAYS Calculation

Viewing 3 reply threads
  • Author
    Posts
  • January 19, 2023 at 2:38 PM #48728

    Mike Guilbault
    Participant

    I have two DAYS calculations, one between Start and Proposal Dates, and one between Proposal & Sold Dates. When the proposal date is empty, I get -19.

    Same as when the Sold date is empty, I get -19.

    Any suggestions as to why?

    Attachments:
    You must be logged in to view attached files.
    January 19, 2023 at 8:20 PM #48737

    Brendan
    Keymaster

    You’ll need to account for empty values by adding an IFEMPTY() function into your DAYS formula.

    January 20, 2023 at 8:28 AM #48740

    Mike Guilbault
    Participant

    Took a few trys at the syntax, but got it. Thanks!

    Actual added Days to Today if the end field was blank.

    IFEMPTY(<PROPOSAL>; DAYS(<START_DATE>;TODAY());DAYS(<START_DATE>;<PROPOSAL>))

    This gives me “days since” Start Date, or “days to” Start Date.

    Cheers!

    January 20, 2023 at 3:07 PM #48755

    Brendan
    Keymaster

    Excellent! I’m glad that worked out for you.

  • Author
    Posts
Viewing 3 reply threads

You must be logged in to reply to this topic.