Date & Time Manipulation

PropertyExpressionDescription
Date & Time
DateAdd(value, unit, interval)
Returns the date in value with interval number of units added. Interval can be positive or negative. Unit must be one of the following: Second, Minute, Hour, Day, Month, Year. For example, the following expression returns "1974-09-01 00:00:00.0000000": DateAdd("1 Jun 1974", "Month", 3)
Date & Time
DatePart(value, datepart)
Returns the datepart component of value. Datepart must be one of the following: Second, Minute, Hour, Day, DayOfWeek, DayOfYear, Month, MonthAbbreviation, MonthName, Year. For example, the following expression returns "1974": DatePart("1 Jun 1974", "Year")