Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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.