topic Re: Set Analysis with dates greater than and missing dates in App Development

Set Analysis with dates greater than and missing dates

PamelaAlcantara — Thu, 28 May 2020 18:58:39 GMT

Hi all,

I am trying to get the number of items that have an initial_date after April 2019 and a closed_date that is not missing.

I have tried the following formula, but I keep getting errors,

count({<Initial_Date={'>=04/01/2019'}, Closed_Date-={"*"}>} items)

Thank you in advance for your help!

Pamela

sunny_talwar — Thu, 28 May 2020 19:04:35 GMT

You want closed date which is not missing? Why do you have a minus sign then? Try this

Count({<Initial_Date = {">=04/01/2019"}, Closed_Date = {"*"}>} items)

PamelaAlcantara — Thu, 28 May 2020 20:57:41 GMT

Yes, I wanted closed date which is not missing. Sorry, that was my bad, I thought the expression {"*"} was looking for the missing values.

Thank you!