Hello,
I am trying to find whether any date comes between specific date range or not.
Ex. In Below screenshot want to check whether Validity_Start_Date is comes in-between Effective_Date and End_Date.
I have put below logic, but not getting desired output.
Effective_Date>=Validity_Start_Date and Validity_Start_Date>=End_Date