Skip to main content
Topics#Data ManagementQuestion de Admin ADP
Admin ADP a posé une question dans #Data Management
2 oct. 2012, 15:24

Report using dynamic "today" feature

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 réponses
  1. James Jetchick (Rivot Digital)
    2 oct. 2012, 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
Rédiger une réponse...
0/9000