Set analysis question

[drohm002]

Hello, I am trying to get a total count of [Accession Number] for only the past 90 days using the today function in set analysis.  What I have listed below isnt working.  Can anyone please help me?

count({<[Begin Date Time]={"$(=Date(Today()-90, 'YYYY/MM/DD'))"}, [Exam Status]={'Complete'}>} [Accession Number])

[Sayed_Mannan]

The issue is with the date comparison. You should use a range for the past 90 days. Here’s the corrected expression:

count({<[Begin Date Time]={">=$(=Date(Today()-90, 'YYYY/MM/DD'))<=$(=Date(Today(), 'YYYY/MM/DD'))"}, [Exam Status]={'Complete'}>} [Accession Number])

Hope this helps.