The date varible in set analysis not working.

[baylor2016]

Hi,

I have tried to find many different ways to make the date variable work in my set analysis - to limit the people's age (18-75) based upon the date selected, but not success. Here are what I have tried:

1.

=count(

{<

FLAG_DM={1}

,YEARSSINCELASTVISIT={"<4"}

,BIRTH_DATE = {"<=$(=$(timestamp(DOB18)))>=$(=$(timestamp(TESTDATE)))"}

>}

DISTINCT PAT_ID

)

2.

=count(

{<

PAT_ID=

{'=FLAG_DM=1'}

*{'=YEARSSINCELASTVISIT < 4'}

*{'=Date(BIRTH_DATE)+6775>today()'}

*{'=date(BIRTH_DATE)+27394<today()'}

>}

DISTINCT PAT_ID

My sample project is attached.

Please help. Thanks

Longmatch

[parimikittu]

BIRTH_DATE = {"=$(=timestamp(TESTDATE))"}. This is the correct syntax.

[baylor2016]

This is my question- the correct syntax does not work in my project. Please look at my attached sample. Thanks

[parimikittu · Accepted solution]

[parimikittu]

have used the above code and it was working. Pls try and let me know