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"

[sunny_talwar]

May be like this:

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

[kevbrown]

That works (however I don't need the datefieldformat as I'm just looking for a number in a text box. Problem is now that when i make a date selection the number changes, I want it to be today no matter what the user selects

[Anonymous]

Hi

based on sunny's solution and your query: ............I want it to be today no matter what.................

try below ?!!

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

[sunny_talwar]

I don't think this should happen, can you share a sample where this is happening for you?

[sunny_talwar]

I don't think 1 should bee needed

[kevbrown]

It's the text box, Occupied Bed Days

[sunny_talwar]

Are you making selection in Date or are you making a selection in Day, Month, Year fields??? If Day, Month and Years are the fields you are making selections in, then you probably need this:

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

[kevbrown]

Perfect, thank you

[kevbrown]

How about the empty beds box?