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:	Select an action to perform with the input.
Result:	Enter a name for a new SCALAR which will contain the resulting value.
Optional Parameters:
Input Pattern:	Enter or select a date pattern corresponding to the input value See Date formats in an EASAP Default: Excel Date
Start Date: when Action: DateAdd, EOMonth, DateDiff	Enter a literal value or SCALAR reference to apply Action: to this start date
End Date: when Action: DateDiff	Enter a literal value or SCALAR reference for an end date
Increment: when Action: DateAdd	Enter a literal or SCALAR reference with an integer number of Intervals: to add Negative numbers allowed Default: 1
Intervals: when Action: DateAdd or DateDiff	Select an interval of: Days, Months or Years Default: Days
Months: when Action: EOMonth	Set an integer number of months to be counted, negative numbers allowed
Days: when Action: WorkDay	Set an integer number of days to be counted, negative numbers allowed
Decimal Places: when Action: YearFrac	number of digit to the right of the decimal place Default: 4
Do if:	logical expression, if true then action performed and not otherwise