function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
crazyforcercrazyforcer 

LAST WEEK and similar values do not work if passed as URL parameters

Hi,

 

I've created a custom report and I've selected a field Date for the Advance Filter section in Step6 (Select your and I have made the value columkn null so that any of values THIS WEEK  or

or LAST WEEK will be taken as value dynamically from the URL when the report will be

called using a custom link of an object.

 

When I'm clicking the custom link, an error will be displayed stating that the date format

is invalid. But if I have given Date = LAST WEEK directly as the filter and run, it will work.

 

Would anyone please give me a solution ?

 

Shabu


 

Best Answer chosen by Admin (Salesforce Developers) 
werewolfwerewolf
I don't think you can URL-hack that.  Just make 2 custom reports, one with a THIS WEEK filter and one with a LAST WEEK filter, and set your URLs to point to each report.