User Tools

Site Tools


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
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
when Action: DateAdd
Enter a literal or SCALAR reference with an integer number of Intervals: to add
Negative numbers allowed
Default: 1
when Action:
DateAdd or DateDiff
Select an interval of: Days, Months or Years
Default: Days
when Action: EOMonth
Set an integer number of months to be counted, negative numbers allowed
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