Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Thanks for your response. Will try it
It will basically return multiple date based year selections