Capture clinic rollout dates by location AND encounter date is specified

[records333]

Hello I would like assistance with following formula:


if ({CLARITY_LOC.LOC_ID} in []//xxx
and
({PAT_ENC_HSP.HOSP_ADMSN_TIME} >= date (2012, 09, 17))
)
then "location name" else

if ({CLARITY_LOC.LOC_ID} in []//xx
and
({PAT_ENC_HSP.HOSP_ADMSN_TIME} >=date (2012, 11, 26) )
)
then "location name"

Problem:
When I add above formula to a group, there is a misc group referenced.
Question:Should I remove or modify selection record;
{CLARITY_LOC.LOC_ID} in [100518.00, 100500.00, 100501.00, 100503.00, 100508.00, 100509.00, 100510.00, 100511.00, 100517.00, 100519.00, 100520.00, 100521.00]AND
{ZC_PAT_CLASS.NAME} in ["Emergency", "Inpatient"] and
{@age} in 18.00 to 85.00 and
{@PCP Name} <> "Nguyen, Tan Van" and
{PAT_ENC_HSP.HOSP_ADMSN_TIME} >= DateTime (2012, 07, 01, 00, 00, 00) and
{PAT_ENC_HSP.ADT_PATIENT_STAT_C} in [2.00, 3.00]

 

[Madawc]

I couldn't make sense of this, and since no one has answered, it seems no one else could either.

Please start a new thread and be more clear. It's no use posting the code without saying what you wanted it to achieve.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP