Using Date Literals
Use date literals to identify a relative time frame instead of a specific date. You can use date literals when defining widget data sources and CRM Workflow conditions and step conditions. These date literals are available in each location but may be formatted differently.
|
Widget Data Source Query Builder mode CRM Workflow conditions CRM Workflow step conditions |
Widget Data Source Raw Query mode |
|---|---|
| Now (current date and time) | :now |
| Today | :today |
| Today (Start of Day) | :todaystart |
| Today (End of Day) | :todayend |
| Today (Timeless) | :todaytimeless |
| Yesterday | :yesterday |
| Yesterday (Start of Day) | :yesterdaystart |
| Yesterday (End of Day) | :yesterdayend |
| Tomorrow | :tomorrow |
| Tomorrow (Start of Day) | :tomorrowstart |
| Tomorrow (End of Day) | :tomorrowend |
| This Week (Start) | :thisweekedstart |
| This Week (End) | :thisweekend |
| This Month (Start) | :thismonthstart |
| This Month (End) | :thismonthend |
| This Year (Start) | :thisyearstart |
| This Year (End) | :thisyearend |
| This Quarter (Start) | :thisquarterstart |
| This Quarter (End) | :thisquarterend |
| Next Week (Start) | :nextweekstart |
| Next Week (End) | :nextweekend |
| Next Month (Start) | :nextmonthstart |
| Next Month (End) | :nextmonthend |
| Next Year (Start) | :nextyearstart |
| Next Year (End) | :nextyearend |
| Next Quarter (Start) | :nextquarterstart |
| Next Quarter (End) | :nextquarterend |
| Last Week (Start) | :lastweekstart |
| Last Week (End) | :lastweekend |
| Last Month (Start) | :lastmonthstart |
| Last Month (End) | :lastmonthend |
| Last Year (Start) | :lastyearstart |
| Last Year (End) | :lastyearend |
| Last Quarter (Start) | :lastquarterstart |
| Last Quarter (End) | :lastquarterend |
| Before Last Year (Start) | :beforelastyearstart |
| Before Last Year (End) | :beforelastyearend |
| This Fiscal Year (Start) | :thisfiscalyearstart |
| This Fiscal Year (End) | :thisfiscalyearend |
| Last Fiscal Year (Start) | :lastfiscalyearstart |
| Last Fiscal Year (End) | :lastfiscalyearend |
| Next Fiscal Year (Start) | :nextfiscalyearstart |
| Next Fiscal Year (End) | :nextfiscalyearend |
| This Fiscal Quarter (Start) | :thisfiscalquarterstart |
| This Fiscal Quarter (End) | :thisfiscalquarterend |
| Last Fiscal Quarter (Start) | :lastfiscalquarterstart |
| Last Fiscal Quarter (End) | :lastfiscalquarterend |
| Next Fiscal Quarter (Start) | :nextfiscalquarterstart |
| Next Fiscal Quarter (End) | :nextfiscalquarterend |
| Same Day Last Year | :samedaylastyear |
| Same Day Last Month | :samedaylastmonth |
| Same Day Last Quarter | :samedaylastquarter |
| Same Day Last Fiscal Year | :samedaylastfiscalyear |
| Same Day Last Fiscal Quarter | :samedaylastfiscalquarter |