Button to Select range is date field

[#1]

Hello,

I am attempting to create a button that sets a date feild to all dates in the past week. Essentially I need to set the field to >Today-8. I have been trying to add a "Select in Field" action that will do this with no luck. Any help would be great.

Thanks!

Jeff

[#2 · Accepted solution]

='>$(=date(today()-8))'

[#3]

I'm not sure how this was implemented, but I'm trying to do the same thing and in the context of a "Select In Field" button, neither this

='>$(=date(today()-8))'

nor this

=date(today()-8)

or this

>$(=date(today()-8))

work at all in the button. Are you sure this is exactly what must be pasted in the search string area? I've got "Select In Field" for the button, and "=add_date" in the Field area (no quotations). Any help? I'd rather not post a duplicate question if I can avoid it.

[#4]

I was unable to make this work using "Today()". However , I have a date feild in my mart that if I take the max will equal today (assuming the data refreshed properly). So the string looks like this:

='>$(=Date(max(TranDate)-8))'

[#5]

i'm sure

post sample file and let me check the problem