Browse


Narrow Search

Feature
Role
Can't find what you need?
Contact Us

Reset Search
    Search Knowledge Base
 
Article

DateLiterals

« Go Back

Information

 
Summary
-

Date Literal

Range

Example

YESTERDAY

Starts 12:00:00 the day before and continues for 24 hours.

Company WHERE CreatedDate = YESTERDAY

TODAY

Starts 12:00:00 of the current day and continues for 24 hours.

Company WHERE CreatedDate > TODAY

TOMORROW

Starts 12:00:00 after the current day and continues for 24 hours.

Comp WHERE CloseDate = TOMORROW

LAST_WEEK

Starts 12:00:00 on the first day of the week before the most recent first day of the week and continues for seven full days. First day of the week is determined by your locale.

Company WHERE CreatedDate > LAST_WEEK

THIS_WEEK

Starts 12:00:00 on the most recent first day of the week before the current day and continues for seven full days. First day of the week is determined by your locale.

Company WHERE CreatedDate < THIS_WEEK

NEXT_WEEK

Starts 12:00:00 on the most recent first day of the week after the current day and continues for seven full days. First day of the week is determined by your locale.

Comp WHERE CloseDate = NEXT_WEEK

LAST_MONTH

Starts 12:00:00 on the first day of the month before the current day and continues for all the days of that month.

Comp WHERE CloseDate > LAST_MONTH

THIS_MONTH

Starts 12:00:00 on the first day of the month that the current day is in and continues for all the days of that month.

Company WHERE CreatedDate < THIS_MONTH

NEXT_MONTH

Starts 12:00:00 on the first day of the month after the month that the current day is in and continues for all the days of that month.

Comp WHERE CloseDate = NEXT_MONTH

LAST_90_DAYS

Starts 12:00:00 of the current day and continues for the last 90 days.

Company WHERE CreatedDate = LAST_90_DAYS

NEXT_90_DAYS

Starts 12:00:00 of the current day and continues for the next 90 days.

Comp WHERE CloseDate > NEXT_90_DAYS

LAST_N_DAYS:n

For the number n provided, starts 12:00:00 of the current day and continues for the last n days.

Company WHERE CreatedDate = LAST_N_DAYS:365

NEXT_N_DAYS:n

For the number n provided, starts 12:00:00 of the current day and continues for the next n DAYS.

Comp WHERE CloseDate > NEXT_N_DAYS:15

THIS_QUARTER

Starts 12:00:00 of the current quarter and continues to the end of the current quarter.

Company WHERE CreatedDate = THIS_QUARTER

LAST_QUARTER

Starts 12:00:00 of the previous quarter and continues to the end of that quarter.

Company WHERE CreatedDate > LAST_QUARTER

NEXT_QUARTER

Starts 12:00:00 of the next quarter and continues to the end of that quarter.

Company WHERE CreatedDate < NEXT_QUARTER

NEXT_N_QUARTERS:n

Starts 12:00:00 of the next quarter and continues to the end of the nth quarter.

Company WHERE CreatedDate < NEXT_N_QUARTERS:2

LAST_N_QUARTERS:n

Starts 12:00:00 of the previous quarter and continues to the end of the previous nth quarter.

Company WHERE CreatedDate > LAST_N_QUARTERS:2

THIS_YEAR

Starts 12:00:00 on January 1 of the current year and continues through the end of December 31 of the current year.

Comp WHERE CloseDate = THIS_YEAR

LAST_YEAR

Starts 12:00:00 on January 1 of the previous year and continues through the end of December 31 of that year.

Comp WHERE CloseDate > LAST_YEAR

NEXT_YEAR

Starts 12:00:00 on January 1 of the following year and continues through the end of December 31 of that year.

Comp WHERE CloseDate < NEXT_YEAR

NEXT_N_YEARS:n

Starts 12:00:00 on January 1 of the following year and continues through the end of December 31 of thenth year.

Comp WHERE CloseDate < NEXT_N_YEARS:5

LAST_N_YEARS:n

Starts 12:00:00 on January 1 of the previous year and continues through the end of December 31 of the previous nth year.

Comp WHERE CloseDate > LAST_N_YEARS:5

THIS_FISCAL_QUARTER

Starts 12:00:00 on the first day of the current fiscal quarter and continues through the end of the last day of the fiscal quarter. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Company WHERE CreatedDate = THIS_FISCAL_QUARTER

LAST_FISCAL_QUARTER

Starts 12:00:00 on the first day of the last fiscal quarter and continues through the end of the last day of that fiscal quarter. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Company WHERE CreatedDate > LAST_FISCAL_QUARTER

NEXT_FISCAL_QUARTER

Starts 12:00:00 on the first day of the next fiscal quarter and continues through the end of the last day of that fiscal quarter. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Company WHERE CreatedDate < NEXT_FISCAL_QUARTER

NEXT_N_FISCAL_​QUARTERS:n

Starts 12:00:00 on the first day of the next fiscal quarter and continues through the end of the last day of the nth fiscal quarter. The fiscal year is defined in the company profile at Setup | Company Profile |Fiscal Year.

Company WHERE CreatedDate < NEXT_N_FISCAL_QUARTERS:6

LAST_N_FISCAL_​QUARTERS:n

Starts 12:00:00 on the first day of the last fiscal quarter and continues through the end of the last day of the previous nth fiscal quarter. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Company WHERE CreatedDate > LAST_N_FISCAL_QUARTERS:6

THIS_FISCAL_YEAR

Starts 12:00:00 on the first day of the current fiscal year and continues through the end of the last day of the fiscal year. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Comp WHERE CloseDate = THIS_FISCAL_YEAR

LAST_FISCAL_YEAR

Starts 12:00:00 on the first day of the last fiscal year and continues through the end of the last day of that fiscal year. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Comp WHERE CloseDate > LAST_FISCAL_YEAR

NEXT_FISCAL_YEAR

Starts 12:00:00 on the first day of the next fiscal year and continues through the end of the last day of that fiscal year. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Comp WHERE CloseDate < NEXT_FISCAL_YEAR

NEXT_N_FISCAL_​YEARS:n

Starts 12:00:00 on the first day of the next fiscal year and continues through the end of the last day of the nth fiscal year. The fiscal year is defined in the company profile at Setup | Company Profile | Fiscal Year.

Comp WHERE CloseDate < NEXT_N_FISCAL_YEARS:3

LAST_N_FISCAL_​YEARS:n

Starts 12:00:00 on the first day of the last fiscal year and continues through the end of the last day of the previous nth fiscal year. The fiscal year is defined in the company profile at Setup | Company Profile |Fiscal Year.

Comp WHERE CloseDate > LAST_N_FISCAL_YEARS:3

Feedback

 

Was this article helpful?



   

Feedback

Please tell us how we can make this article more useful.

Characters Remaining: 255

 

Apto