Skip to main content
Admin ADP が「#Data Management」で質問
I'm trying to create a report where I pull all records that have a "Project Start Date" before "today".  Since I want this report to be run automatically once a week, I need the filter for "today" to be dynamic.  Is there a way to do this? 
2 件の回答
  1. 2012年10月2日 15:33
    Yes, you can actually just type the word TODAY instead of inputting a date. Create a new filter on the date field you are interest in limiting, date literals will not work in the date range fields that come on every report.

     

    These are the Date Literals, useful bookmark: http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm

     

    You can replace the underscores with spaces for reports , LAST_WEEK becomes LAST WEEK