Calculate age between today or start and end dates

I would like to calculate the age (number of days) between start and end dates or today's date and the start date.

I need to check if the start date is populated first.

If so, then check if the end date is populated.

If end date exists, then calculate the number of days between the end date and the start date.

If end date does not exist, then calculate the number of days between today and the start date.

If start date does not exist, then ""

Parents
  • Hello Peter, 

    Could you please check if this works on your end?

    It worked in my tests, but I want to make sure I’ve correctly captured all your requirements.


    ifElse(
      not(equal($date_start, "")),
      ifElse(
        not(equal($date_end, "")),
        abs(subtract(daysUntil($date_end), daysUntil($date_start))),
        abs(daysUntil($date_start))
      ),
      ""
    )


    This is what the formula is doing: 

    Check if date_start is populated: If it’s empty, the formula returns an empty string

    If date_start is populated checks if date_end is populated: 

    yes: Calculate the absolute difference in days between date_end and date_start

    If no: Calculate the absolute number of days from date_start to today with the daysUntil.

    Is this what you need? 

    Cheers, 

    André 



Reply
  • Hello Peter, 

    Could you please check if this works on your end?

    It worked in my tests, but I want to make sure I’ve correctly captured all your requirements.


    ifElse(
      not(equal($date_start, "")),
      ifElse(
        not(equal($date_end, "")),
        abs(subtract(daysUntil($date_end), daysUntil($date_start))),
        abs(daysUntil($date_start))
      ),
      ""
    )


    This is what the formula is doing: 

    Check if date_start is populated: If it’s empty, the formula returns an empty string

    If date_start is populated checks if date_end is populated: 

    yes: Calculate the absolute difference in days between date_end and date_start

    If no: Calculate the absolute number of days from date_start to today with the daysUntil.

    Is this what you need? 

    Cheers, 

    André 



Children
No Data