Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
='>$(=date(today()-8))'
='>$(=date(today()-8))'
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.
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))'
i'm sure
post sample file and let me check the problem