Version

FormatConditionTimePeriod Enumeration

Constants which define the manner in which a cell's date/time value is compared when evaluating a DateTimeConditionalFormat.
Syntax
public enum FormatConditionTimePeriod : System.Enum 
Members
MemberDescription
LastMonthThe cell's date/time value is compared to the month before the current one.
LastSevenDaysThe cell's date/time value meets the condition if it lies within the range of the past seven days, without regard to the System.Globalization.CalendarWeekRule.
LastWeekThe cell's date/time value is compared to the week before the current one, as defined by the System.Globalization.CalendarWeekRule.
NextMonthThe cell's date/time value is compared to the month after the current one.
NextWeekThe cell's date/time value is compared to the week after the current one, as defined by the System.Globalization.CalendarWeekRule.
ThisMonthThe cell's date/time value is compared to the current month.
ThisWeekThe cell's date/time value is compared to the current week, as defined by the System.Globalization.CalendarWeekRule.
TodayThe cell's date/time value is compared to the current date.
TomorrowThe cell's date/time value is compared to the day after the current date.
YesterdayThe cell's date/time value is compared to the day before the current date.
Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also