Salesforce Date Literals
I got tired of having to look them up so here are the Salesforce date literals for reference:
These work equally well in reports, formulas, listviews, workflows, and SOQL statements.
| Date Literals |
|---|
| YESTERDAY |
| TODAY |
| TOMORROW |
| LAST_WEEK |
| THIS_WEEK |
| NEXT_WEEK |
| LAST_MONTH |
| THIS_MONTH |
| NEXT_MONTH |
| LAST_90_DAYS |
| NEXT_90_DAYS |
| LAST_N_DAYS:n |
| NEXT_N_DAYS:n |
| THIS_QUARTER |
| LAST_QUARTER |
| NEXT_QUARTER |
| NEXT_N_QUARTERS:n |
| LAST_N_QUARTERS:n |
| THIS_YEAR |
| LAST_YEAR |
| NEXT_YEAR |
| NEXT_N_YEARS:n |
| LAST_N_YEARS:n |
| THIS_FISCAL_QUARTER |
| LAST_FISCAL_QUARTER |
| NEXT_FISCAL_QUARTER |
| NEXT_N_FISCAL_QUARTERS:n |
| LAST_N_FISCAL_QUARTERS:n |
| THIS_FISCAL_YEAR |
| LAST_FISCAL_YEAR |
| NEXT_FISCAL_YEAR |
| NEXT_N_FISCAL_YEARS:n |
| LAST_N_FISCAL_YEARS:n |
0 comments:
Post a Comment