Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - Here is a scenario where I need to perform 4 opetarions in OR condition
Condition # | Condition | ||
1 | EFF_DT between FROM_DT and TO_DT | ||
2 | TERM_DT between FROM_DT and TO_DT | ||
3 | FROM_DT between EFF_DT and TERM_DT | ||
4 | TO_DT between EFF_DT and TERM_DT |
COUNT({<MEM_GENDER = {'M'}, MEM_EFF_DT = {">=$(=Date(vFromDate))"}*{"<=$(=Date(vToDate))"},FLAG_ELIG_PERSON_KEY ={1}>} DISTINCT PERSON_KEY)
Highlighted above has first condition, I dont know how to implement rest 3 onditions in OR. Can someone pls help me?
Something like this:
COUNT({<MEM_GENDER = {'M'}, MEM_EFF_DT = {">=$(=Date(vFromDate))<=$(=Date(vToDate))"},FLAG_ELIG_PERSON_KEY ={1}>
+
<MEM_GENDER = {'M'}, MEM_TERM_DT = {">=$(=Date(vFromDate))<=$(=Date(vToDate))"},FLAG_ELIG_PERSON_KEY ={1}>
+
<MEM_GENDER = {'M'}, MEM_TERM_DT = {">=$(=Date(vFromDate))"}, MEM_EFF_DT = {"<=$(=Date(vFromDate))"} ,FLAG_ELIG_PERSON_KEY ={1}>
+
<MEM_GENDER = {'M'}, MEM_TERM_DT = {">=$(=Date(vToDate))"}, MEM_EFF_DT = {"<=$(=Date(vToDate))"} ,FLAG_ELIG_PERSON_KEY ={1}>
} DISTINCT PERSON_KEY)