Adding Date to set analysis

[kevbrown]

I'm looking at some set analysis and have the following -

=Count( { < [Specialty Code] = { '700' } > } [Bed Days.Occupied])

I want to add a date criteria to is so it only looks at yesterdays date. My date field is called "Date"

[kevbrown · Accepted solution]

Think I've done it

=Sum( { <[Specialty Code] = { '700' }, [Date] = {"$(=Date(Today() -1))"}, InfoCalDay, InfoCalMonth, InfoCalYear>} [Available Beds.Beds Available])-

Count( { <[Specialty Code] = { '700' }, [Date] = {"$(=Date(Today() -1))"}, InfoCalDay, InfoCalMonth, InfoCalYear>} [Bed Days.Occupied])

[sunny_talwar]

Looks good to me if it gives you what you want

[kevbrown]

Why is this not working?

=Count({<[Specialty Code] = { '700' },[Outcome] = { 'Attended' }, Date = {"$(=Date (Today() -1))"}, InfoCalDay, InfoCalMonth, InfoCalYear>} [refrl_refno])

[maheshkuttappa]

try date  format to match the Date field , something like below

Date = {"$(=Date(Today() -1,'MM/DD/YYYY'))"}