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.