AND Condition for Same date fields

[selvakumara]

Hi ,

I want to get the lessthan 24 months and greater than 12 months data using set expression.

This is my set expression.

COUNT({($<id]={'17'},[DATE]={"<=$(AddMonths(ADMISSION_DATE,24), 'MM-DD-YYYY')"},[DATE]={">=$(AddMonths(ADMISSION_DATE,12), 'MM-DD-YYYY')"} >)} [Name])

Is it correct ?

Thanks,

Selva

[agigliotti]

maybe this:

= COUNT( {< id = {'17'}, DATE = {"<=$(=AddMonths(ADMISSION_DATE,24))>=$(=AddMonths(ADMISSION_DATE,12))"} >) Name )

I hope it's really what you are looking for.

[stigchel]

Try with

COUNT({$<[DATE]={">=$(=Date(AddMonths(ADMISSION_DATE,12), 'MM-DD-YYYY'))<=$(=Date(AddMonths(ADMISSION_DATE,24), 'MM-DD-YYYY'))"}>} [Name])

Where ADMISSION_DATE is one single date

[selvakumara]

Thanks for your response. Will try it

[selvakumara]

It will basically return multiple date based year selections