Numbers of Days in selection

[george_1955]

How calculate the number of calendar days in the period selections, regardless of the selections on the tables?

Thank You,

[sunny_talwar]

John -

Why would this not work?

Max({1<Month = $::Month, Year = $::Year, Date = $::Date, Quarter = $::Quarter, MonthYear =$::MonthYear>}Date) - Min({1<Month = $::Month, Year = $::Year, Date = $::Date, Quarter =$::Quarter, MonthYear = $::MonthYear>}Date)

[johnw]

Ah, yeah, that should work. Or because I'm crazy and have to make things more complicated in the name of making them simpler:

max({1<[$(=concat({<[$Table]={'Calendar'}>} distinct [$Field]&']=$::['&[$Field],'],['))]>} [Date]) - min({1<[$(=concat({<[$Table]={'Calendar'}>} distinct [$Field]&']=$::['&[$Field],'],['))]>} [Date])