Use this link to share with your colleagues:
Relative Date Values: https://help.pm.leapevent.tech/a/829742
If you'd like to see results based on a rolling date range in your list views or reports, you can use the following relative date values in your filters. These date values can also be used in workflow rule criteria.
Here's a list of relative date values you can use in workflow rule criteria, list views, and reports.
YESTERDAY: Starts 12:00:00 the day before and continues for 24 hours.
TODAY: Starts 12:00:00 of the current day and continues for 24 hours.
TOMORROW: Starts 12:00:00 after the current day and continues for 24 hours.
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. Your locale determines the first day of the 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. Your locale determines the first day of the 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. Your locale determines the first day of the 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.
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.
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.
LAST_90_DAYS: Starts 12:00:00 of the current day and continues for the past 90 days.
NEXT_90_DAYS: Starts 12:00:00 of the current day and continues for the next 90 days.
LAST_N_DAYS:n: For the number n provided, starts 12:00:00 of the current day and continues for the past n days.
NEXT_N_DAYS:n: For the number n provided, starts 12:00:00 of the current day and continues for the next n days.
NEXT_N_WEEKS:n: For the number n provided, starts 12:00:00 of the first day of the next week and continues for the next n weeks.
LAST_N_WEEKS:n: For the number n provided, starts 12:00:00 of the last day of the previous week and continues for the past n weeks.
NEXT_N_MONTHS:n: For the number n provided, starts 12:00:00 of the first day of the next month and continues for the next n months.
LAST_N_MONTHS:n: For the number n provided, starts 12:00:00 of the last day of the previous month and continues for the past n months.
THIS_QUARTER: Starts 12:00:00 of the current quarter and continues to the end of the current quarter.
LAST_QUARTER: Starts 12:00:00 of the previous quarter and continues to the end of that quarter.
NEXT_QUARTER: Starts 12:00:00 of the next quarter and continues to the end of that quarter.
NEXT_N_QUARTERS:n: Starts 12:00:00 of the next quarter and continues to the end of the nth quarter.
LAST_N_QUARTERS:n: Starts 12:00:00 of the previous quarter and continues to the end of the previous nth quarter.
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.
LAST_YEAR: Starts 12:00:00 on January 1 of the previous year and continues through the end of December 31 of that 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.
NEXT_N_YEARS:n: Starts 12:00:00 on January 1 of the following year and continues through the end of December 31 of the nth year.
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.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.
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 on the Fiscal Year page in Setup.