| Excerpt | ||
|---|---|---|
| ||
dateSet(date, dateField, dateValue) Sets an element of a date (e.g. the month) and returns the new date. |
Function: dateSet()
Sets an element of a date (e.g. the month) and returns the new date.
...
dateSet(date, dateField, dateValue)
| Argument | Type | Description |
|---|---|---|
| date | Date | The original date/time |
| dateField | Date Field | The part of the date to be be changed (e.g. the month or seconds) |
| dateValue | Date Value | The new value for that date element |
When updating the day of the week (e.g. to _SATURDAY), the result will be the date for that day of the week in the current week - and weeks being on Monday. See examples below.
Examples
dateSet("20100403.162359", _MONTH, 3)
Sets the month to 3 so returns the date/time "20100303.162359"
dateSet("in.invoiceDate", _MONTH, _JANUARY)
Returns in.invoiceDate with the month set to 1 (January) e.g. "20100303.162359" would become "20100103.162359"
dateSet("in.invoiceDate",_SECOND, 0)
Returns in.invoiceDate with the seconds set to 0. e.g. "20100303.162359" would become e.g. "20100303.162300".
...
Remember, when updating the day of the week, the resulting date will be that day of the week in the current week, and weeks begin on Monday. For example, if you use an input date which is a Thursday, setting the day of the week to Monday, Tuesday or Wednesday will give you an ealier date than the input; setting the day of the week to Friday, Saturday or Sunday will give you a later date than the input.
dateSet(toDate("20131205"), _DAY_OF_WEEK, _TUESDAY)
The input date 20131205 is a Thursday, so this will give 20131203.
dateSet(toDate("20131205"), _DAY_OF_WEEK, _SATURDAY)
The input date 20131205 is a Thursday, so this will give 20131207.
...