DATE
Usage
TIBCO iProcess Workspace (Browser)
TIBCO iProcess Workspace (Windows)
Constructs a date from the specified day, month and year
Syntax
DATE (day, month, year)
where:
| • | day is a numeric value in the range 1-(number of days in month) |
| • | month is a numeric value in the range 1-12 |
| • | year is a numeric value in the range 0-2999 |
Returns
date (or SW_NA for an invalid date)
Examples
TIBCO iProcess Modeler:
This example returns the date of the first day of the next month:
DATE (1, MONTHNUM (CALCDATE (sw_date, 0, 0, 1,
0)), YEARNUM (CALCDATE (sw_date, 0, 0, 1, 0)))
TIBCO Business Studio:
IPEDateTimeUtil.DATE(1,
IPEDateTimeUtil.MONTHNUM(IPEDateTimeUtil.CALCDATE(IPESystemValues.SW_DATE, 0, 0, 1, 0)),
IPEDateTimeUtil.YEARNUM(IPEDateTimeUtil.CALCDATE(IPESystemValues.
SW_DATE, 0, 0, 1, 0)));