shieldsco
asked on
SAS 9.4 Query Between Dates
I'm using the SAS query however it's not returning the records between the two dates.
All records are returned.
Select TASKAPL .0FC_Nf1, TASKS .MMBR_FULL_NM , TASKS.SUPRYSR_FULL_NM,
TASKAPL.ALJ_APL_NUM, TASKS.TASK_ASGNED_DT, TASKS.INI T IATED_DT,
TASKS.CMPLTD_DT, TASKS.TASK_TYPE_NM. TASKS.TASK_STATUS_NM,
TASKAPL.WRKFLM_S TA TE_NM, TASKAPL.PRCSG_M THD_NM,
TASKAPL.CMPL T_RQS T_RCUD_D T, TASKAPL.CRNT_AGE,
TASKAPL.FY_CMPLT_REQ_RCVD_DT, TASKAPL.APLNT_FULL_NM, TASKAPL.BENE_CNT, TASKAPL.CLM_CNT, TASKAPL.DLM_DT, TASKAPL.COMB INED_ID,
TASKAPL.COMB INED_NAME, TASKAPL.COMB INED_APL_PAREN T_IND,
TASKAPL.FY_RQST_RCUD_DT, TASKAPL.FY_DLM_DT from TASKS.TASKAPL LEFT JOIN TASKS.TASKS
ON TASKAPL. APPEALED =TASKS . APPEAL_ ID where TASKS.TASK_STATUS_NM IN( ’Closed' )
OR TASKS.TASK_STATUS_NM INC (’Not Completed' )
AND TASKS.CMPLTD_DT Between '010ct2019’d and ’30Sep2020'd;
All records are returned.
Select TASKAPL .0FC_Nf1, TASKS .MMBR_FULL_NM , TASKS.SUPRYSR_FULL_NM,
TASKAPL.ALJ_APL_NUM, TASKS.TASK_ASGNED_DT, TASKS.INI T IATED_DT,
TASKS.CMPLTD_DT, TASKS.TASK_TYPE_NM. TASKS.TASK_STATUS_NM,
TASKAPL.WRKFLM_S TA TE_NM, TASKAPL.PRCSG_M THD_NM,
TASKAPL.CMPL T_RQS T_RCUD_D T, TASKAPL.CRNT_AGE,
TASKAPL.FY_CMPLT_REQ_RCVD_DT, TASKAPL.APLNT_FULL_NM, TASKAPL.BENE_CNT, TASKAPL.CLM_CNT, TASKAPL.DLM_DT, TASKAPL.COMB INED_ID,
TASKAPL.COMB INED_NAME, TASKAPL.COMB INED_APL_PAREN T_IND,
TASKAPL.FY_RQST_RCUD_DT, TASKAPL.FY_DLM_DT from TASKS.TASKAPL LEFT JOIN TASKS.TASKS
ON TASKAPL. APPEALED =TASKS . APPEAL_ ID where TASKS.TASK_STATUS_NM IN( ’Closed' )
OR TASKS.TASK_STATUS_NM INC (’Not Completed' )
AND TASKS.CMPLTD_DT Between '010ct2019’d and ’30Sep2020'd;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.