A SWITCH (TRUE ()) construct should work perfectly here. Please check out the post below from Expert @Harsh where he shows how to implement this with a compound condition in the first parameter of the SWITCH(TRUE()) using “&&”. That’s the way the cool kids do it, which is equivalent to the more formal construct of using AND(condition 1, condition 2), which in your case will be greater than or equal to the first date and less than or equal to the second date.