Set Analysis between two dates

[billuran]

Hello, I want to do set analysis with dates. Here is my basic function:

sum(Hours)

My date Field is PP

I want sum hours that are equal to or between the max available date and 42 days before this.

Here is my first attempt.

sum({<[Exclude Hours]={'NO'},PP={'>=$(=Date(max({1}PP)))<=$(=Date(max({1}PP)-42))'},Overtime={'OT'}>} Hours)

It however is not working for the specified date range

[swuehl · Accepted solution]

shouldn't it be like

PP={'>=$(=Date(max({1}PP)-42))<=$(=Date(max({1}PP)))'}

[billuran]

Stefan, As always thank you. Silly by me...