Days from date field value filter

sgagliardi — Thu, 04 Apr 2019 20:11:01 GMT

I've been struggling with a requirement for a couple of weeks now that I can't seem to get right. It seems like it should be a simple one, but I'm not getting the results I'm looking for.

I have a date field in my data set called DISCHARGE_DATE, and another called ADMIT_DATE. I want to create a filter like "10 days, 20 days, 30 days, est..." that will filter for all admit dates occurring within those days of a DISCHARGE_DATE. Where I'm at now:

=if(ADMIT_DATE<=date(DISCHARGE_DATE,+10),'10 Days',if(ADMIT_DATE<=date(DISCHARGE_DATE,+20),'20 Days',''))

topic Days from date field value filter in App Development

Days from date field value filter