User Tools

Site Tools


DATE FUNCTION

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 Formats in an EASAP.
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.