A count of values for yesturdays date

[helen_pip]

Hello

I am looking to gain some help with writing some syntex

My scenario is that I have a volume of patients and would like to know how many patients we had in hospital yesturday.  Yet all I have as a date is the patients admission date, and a patient could have been admitted yesturday or 2 weeks before yesturday, yet I would want to count both.

I know the syntex should be something like the following:

If(Today()-1 >= admission_date and <=Today()-1,1)

Is anyone able to help me

Kind Regards

Helen

[swuehl · Accepted solution]

Maybe

=Count(DISTINCT  If( admission_date <= Today()-1, patientID))

[helen_pip]

Thanks so much

That works for me!

Thanks

Helen