User Tools

Site Tools


DATE FUNCTION

Guide Section: Date Formats in an EASAP | EASAP Tree: EVENT PROCESSINGACTION


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.

Page Tools