Thursday, 04 May 2020
To optimize the results of filters applied to date fields in Salesforce Reports and List Views, you can use relative dates instead of specific dates.
Here’s the list of relative values in Salesforce in English and Spanish:
| Value in English | Value in Spanish |
| YESTERDAY TODAY TOMORROW LAST WEEK THIS WEEK NEXT WEEK LAST MONTH THIS MONTH NEXT MONTH LAST QUARTER THIS QUARTER NEXT QUARTER LAST FISCAL QUARTER THIS FISCAL QUARTER NEXT FISCAL QUARTER LAST YEAR THIS YEAR NEXT YEAR LAST FISCAL YEAR THIS FISCAL YEAR NEXT FISCAL YEAR LAST 90 DAYS NEXT 90 DAYS n DAYS AGO n WEEKS AGO n MONTHS AGO n QUARTERS AGO n FISCAL QUARTERS AGO n YEARS AGO n FISCAL YEARS AGO | AYER HOY MAÑANA SEMANA PASADA ESTA SEMANA PRÓXIMA SEMANA MES PASADO ESTE MES PRÓXIMO MES ÚLTIMO TRIMESTRE ESTE TRIMESTRE SIGUIENTE TRIMESTRE ÚLTIMO TRIMESTRE FISCAL ESTE TRIMESTRE FISCAL SIGUIENTE TRIMESTRE FISCAL ÚLTIMO AÑO ESTE AÑO SIGUIENTE AÑO ÚLTIMO AÑO FISCAL ESTE AÑO FISCAL SIGUIENTE AÑO FISCAL LOS ÚLTIMOS 90 DÍAS LOS PRÓXIMOS 90 DÍAS HACE n DÍAS HACE n SEMANAS HACE n MESES HACE n TRIMESTRES HACE n TRIMESTRES FISCALES HACE n AÑOS HACE n AÑOS FISCALES |
It is important to consider two aspects:
- You must enter the relative date value for the language that the user has configured in Salesforce.
- The second that some of these values such as “LAST WEEK” refer to weeks, and therefore the locale that we have in our computer will affect the result (for example if we have the configuration “English (United States)”, the week begins on Sunday, while in the configuration “Spanish (Spain)” the week begins on Monday).
