One thing that defines great sys admins and report writers in Salesforce.com is their ability to filter on desired data in Views, Reports, Workflow Rules, Assignment Rules, etc. In support of this, in all of its editions Salesforce has given us 33 super useful Special Date values that we can use to create dynamic filter criteria, such as “Tomorrow”, “Last (n number of) Days”, “Next Quarter”, “This Week” , “Next Fiscal Year” and so on. You can see the full list of these useful values under Help at Special Date Values for Filter Criteria.
A few examples of Special Date Values in action:
A few considerations:
Use the comments section to share any examples have you’ve come up with!
Sign up for weekly OpFocus blog updates!