Date Field Filter Conditions Description
Print
Created by: Krati katiyar
Modified on: Fri, 17 Feb, 2017 at 3:55 PM
The Date field used in workflows and sharing rule has got multiple filter conditions and every other filter serves a different purpose. The description of almost all the available date filters are given below:
Filter Condition |
Description |
|
|
Yesterday |
Starts at 12:00:00 a.m. on the day before the current day and continues for 24 hours.
|
Today |
Starts at 12:00:00 a.m. on the current day and continues for 24 hours.
|
Tomorrow |
Starts at 12:00:00 a.m. on the day after the current day and continues for 24 hours.
|
Last Week |
Starts at 12:00:00 a.m. on the first day of the week before the current week and continues for seven days.
|
This Week |
Starts at 12:00:00 a.m. on the first day of the current week and continues for seven days.
|
Next Week |
Starts at 12:00:00 a.m. on the first day of the week after the current week and continues for seven days.
|
Last N Weeks |
Starts at 12:00:00 a.m. on the first day of the week that started n weeks before the current week, and continues up to 11:59 p.m on the last day of the week before the current week.
|
Next N Weeks |
Starts at 12:00:00 a.m. on the first day of the week after the current week and continues for n times seven days.
|
N Weeks Ago |
Starts at 12:00:00 a.m. on the first day of the week that started n weeks before the start of the current week and continues for seven days.
|
-/+ N Weeks |
Starts at 12:00:00 a.m. on the first day of the week that started n weeks before the current week, and continues for n times seven days ending at 11:59 p.m on the last day.
|
Last Month |
Starts at 12:00:00 a.m. on the first day of the month before the current month and continues for all the days of that month.
|
This Month |
Starts at 12:00:00 a.m. on the first day of the current month and continues for all the days of that month.
|
Next Month |
Starts at 12:00:00 a.m. on the first day of the month after the current month and continues for all the days of that month.
|
Last N Months |
Starts at 12:00:00 a.m. on the first day of the month that started n months before the current month and continues up to 11:59 p.m on the last day of the month before the current month.
|
Next N Months |
Starts at 12:00:00 a.m. on the first day of the month after the current month and continues until the end of the nth month.
|
N Months Ago |
Starts at 12:00:00 a.m. on the first day of the month that started n months before the start of the current month and continues for all the days of that month.
|
-/+ N Months |
Starts at 12:00:00 a.m. on the first day of the month that started n months before the current month, and continues until the end of the nth month from the current month.
|
Last 90 Days |
Starts at 12:00:00 a.m. 90 days before the current day and continues up to the current second. (The range includes today.)
|
Next 90 Days |
Starts at 12:00:00 a.m. on the day after the current day and continues for 90 days. (The range does not include today.)
|
Last N Days |
Starts at 12:00:00 a.m. n days before the current day and continues up to the current second. (The range includes today. Using this date value creates a list including records from n + 1 days ago up to the current day.)
|
Next N Days |
Starts at 12:00:00 a.m. on the next day and continues for the next n days. (The range does not include today.)
|
N Days Ago
|
Starts at 12:00:00 a.m. on the day n days before the current day and continues for 24 hours. (The range does not include today.)
|
-/+ N Days |
Starts at 12:00:00 a.m. n days before the current day and continues for the next n days from the current day.
|
Last Year |
Starts at 12:00:00 a.m. on January 1 of the year before the current year and continues through the end of December 31 of that year.
|
This Year |
Starts at 12:00:00 a.m. on January 1 of the current year and continues through the end of December 31 of the current year.
|
Next Year |
Starts at 12:00:00 a.m. on January 1 of the year after the current year and continues through the end of December 31 of that year.
|
Last N Years |
Starts at 12:00:00 am on January 1, n+1 years ago. The range ends on December 31 of the year before the current year.
|
Next N Years |
Starts at 12:00:00 a.m. on January 1 of the year after the current year and continues through the end of December 31 of the nth year.
|
N Years Ago |
Starts at 12:00:00 a.m. on January 1 of the calendar year n years before the current calendar year and continues through the end of December 31 of that year.
|
-/+ N Years |
Starts at 12:00:00 am on January 1, n+1 years ago and continues through the end of December 31 of the nth year from the current year.
|
Krati is the author of this solution article.
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.