Guide Section: N/A | EASAP Tree: EVENT PROCESSING Branch

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

The available modes for this object are detailed below:

• DateAdd: takes a date and adds/subtracts the specified amount of intervals and returns the appropriate date in the same format
• DateDiff: compares two dates of the same format and returns the number of intervals between them
• EOMonth: returns the last day of a desired month in the specified date format
• Weekday: returns the number of the day in a week, ranges from 1 through 7 where Sunday is the first day of the week
• WorkDay: returns the date that is later/earlier by the specified amount of workdays from the initial date
• YearFrac: returns the difference between two dates expressed in years, real number with specified amount of decimal places

DATE FUNCTION
Essential Parameters:
Action:	The action to perform with the input.
Result:	The name of the DOR to contain the resulting value.
Optional Parameters:
Input Pattern:	The date pattern corresponding to the input value. See DATE FUNCTION.
Start Date:	Available for DateAdd, EOMonth, DateDiff ACTIONs. The starting date to perform the action on.
End Date:	Available for DateDiff ACTION. The ending date to perform the action on.
Increment:	Available for DateAdd ACTION. Integer, the number of intervals to add. Accepts negative numbers as well.
Intervals:	Available for DateAdd, DateDiff ACTIONs. Available selections are: Days, Months, Years
Months:	Available for EOMonth ACTION. Integer, number of months. Accepts negative numbers.
Days:	Available for WorkDay ACTION. Integer, the number of days to be counted. Accepts negative numbers.
Decimal Places:	Available for YearFrac ACTION.
Do if:	Logical expression, if TRUE then action performed, if FALSE then action NOT performed.