Forum Discussion

pbrainard's avatar
pbrainard
Icon for Helper III rankHelper III
4 years ago
Solved

Count between two dates OR

I want to be able to get a count of records where StartDate is less than (slider value) and EndDate is greater than (slider value) OR EndDate is blank. I got as far as setting up the sliders, but how...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Use COALESCE() to catch the scenario when the end date is blank.

pbrainard's avatar
pbrainard
Icon for Helper III rankHelper III
4 years ago

Thank you!!