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