Date and Time Manipulations
FormatDate
Represents formatting a date.
{
"ExpressionType": "FormatDate",
"Format": "mm/dd/yyyy"
}UtcNow
Represents getting the current UTC time.
{
"ExpressionType": "UtcNow"
}YearOf
Represents extracting the year from a date.
{
"ExpressionType": "YearOf"
}MonthOf
Represents extracting the month from a date.
{
"ExpressionType": "MonthOf"
}DayOf
Represents extracting the day from a date.
{
"ExpressionType": "DayOf"
}AddDays
Represents adding days to a date.
{
"ExpressionType": "AddDays",
"NumberOfDays": 3
}AddMonths
Represents adding months to a date.
{
"ExpressionType": "AddMonths",
"NumberOfMonths": 3
}AddYears
Represents adding years to a date.
{
"ExpressionType": "AddYears",
"NumberOfYears": 3
}SubstractDays
Represents subtracting days from a date.
{
"ExpressionType": "SubstractDays",
"NumberOfDays": 3
}SubstractMonths
Represents subtracting months from a date.
{
"ExpressionType": "SubstractMonths",
"NumberOfMonths": 3
}SubstractYears
Represents subtracting years from a date.
{
"ExpressionType": "SubstractYears",
"NumberOfYears": 3
}DateDifference
Represents difference between two date.
{
"ExpressionType": "DateDifference",
"StartDate": {
"ExpressionType": "UtcNow"
},
"EndDate": {
"ExpressionType": "UtcNow"
},
"Interval": "Year" ("Year", "Quarter", "Month", "Day", "Dayofyear", "Weekday", "Week", "Hour", "Minute", "Second")
}