David Mendez Otero
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 |
|---|---|
| YESTERDAYTODAYTOMORROWLAST WEEKTHIS WEEKNEXT WEEKLAST MONTHTHIS MONTHNEXT MONTHLAST QUARTERTHIS QUARTERNEXT QUARTERLAST FISCAL QUARTERTHIS FISCAL QUARTERNEXT FISCAL QUARTERLAST YEARTHIS YEARNEXT YEARLAST FISCAL YEARTHIS FISCAL YEARNEXT FISCAL YEARLAST 90 DAYSNEXT 90 DAYSn DAYS AGOn WEEKS AGOn MONTHS AGOn QUARTERS AGOn FISCAL QUARTERS AGOn YEARS AGOn FISCAL YEARS AGO | AYERHOYMAÑANASEMANA PASADAESTA SEMANAPRÓXIMA SEMANAMES PASADOESTE MESPRÓXIMO MESÚLTIMO TRIMESTREESTE TRIMESTRESIGUIENTE TRIMESTREÚLTIMO TRIMESTRE FISCALESTE TRIMESTRE FISCALSIGUIENTE TRIMESTRE FISCALÚLTIMO AÑOESTE AÑOSIGUIENTE AÑOÚLTIMO AÑO FISCALESTE AÑO FISCALSIGUIENTE AÑO FISCALLOS ÚLTIMOS 90 DÍASLOS PRÓXIMOS 90 DÍASHACE n DÍASHACE n SEMANASHACE n MESESHACE n TRIMESTRESHACE n TRIMESTRES FISCALESHACE n AÑOSHACE 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).
