Guide Section: Date Formats in an EASAP | EASAP Tree: EVENT PROCESSING → ACTION

DATE FUNCTION carries out date operations in common with Excel's date functions.

• Action: specifies one of the modes below,
  • DateAdd → Return a new date with the specified number of intervals added to it
  • DateDiff → Return the number of intervals between two dates of the same format
  • EOMonth → Return the last day of a desired month in the specified date format
  • Weekday → Return the number of the day in a week, Sunday is 1 through Saturday 7)
  • WorkDay → Return the date that is later by the specified amount of workdays from the initial date
  • YearFrac → Return the difference between two dates as a real (ie. decimal) number of years

DATE FUNCTION
Essential Parameters:
Action:	The action to perform with the input.
Result:	The name of a new explicit SCALAR which will contain the resulting value.
Optional Parameters:
Input Pattern:	The date pattern corresponding to the input value, by default→Excel Date, see Date Formats in an EASAP.
Start Date:	Apply Action: to this start date. (Applies when Action:→ DateAdd, EOMonth or DateDiff)
End Date:	Apply Action: to this end date. (Applies when Action:→DateDiff)
Increment:	An integer number of Intervals: to be added, negative numbers allowed. (Applies when Action:→DateAdd)
Intervals:	Choose an interval of Days, Months or Years. (Applies when Action: → DateAdd or DateDiff)
Months:	An integer number of months to be counted, negative numbers allowed. (Applies when Action:→EOMonth)
Days:	An integer number of days to be counted, negative numbers allowed. (Applies when Action:→WorkDay)
Decimal Places:	The number of digit to the right of the decimal place. (Applies when Action:→YearFrac)
Do if:	Logical expression, if TRUE then action performed, if FALSE then action NOT performed.