Set Default Selection of Dates within a specific range

[billuran]

Hello, All.

I want a list box to default select the max date and any dates that fall within 56 days before it (4 pay periods).

My date field name is PP

Any help would be great!

[swuehl]

Maybe you can use a Selection - Select in field action with field name PP and as search string

='=PP<=Max(TOTAL PP) and PP>=Max(TOTAL PP)-56'

[billuran]

Soi inputted this but it is not refreshing, still showing any date in my list box.

[swuehl]

I believe the field name should just be

PP

(no equal sign)