...
Sets an element of a date (e.g. the month) , such as the day or month, and returns the new date.
Syntax
dateSet(date,dateField,dateValue)
| Argument |
|---|
| Parameter Types | Description | |
|---|---|---|
| date | Date | The original |
| date or date-time. For the current date-time use the attribute function now(). | |
| dateField | See Date |
| -Time Functions | The |
| element of the date to be be changed |
| , for example the month or seconds |
| . |
| dateValue |
| The new value for that date element |
...
| . |
| Tip |
|---|
Changing a date-time to a different |
...
Examples
to:
|
Examples
| Example | Returns |
|---|---|
dateSet(today(),_DAY,1) | Sets the Day to the first for the current month and year. |
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) |
...
. An invoice date of "20100303.162359" |
...
becomes "20100103.162359" | |
dateSet("in.invoiceDate",_SECOND, 0) | Returns in.invoiceDate with the seconds set to 0. |
...
| An invoice date-time of "20100303.162359" |
...
| becomes "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 of "20131205" is a Thursday |
...
| . This returns the date for the Tuesday in the same week, "20131203". | |
dateSet(toDate("20131205"),_DAY_OF_WEEK,_SATURDAY) | The input date of "20131205" is a Thursday |
...
| . This returns the date for the Saturday in the same week "20131207". |
See Also
...
| Excerpt | ||
|---|---|---|
| ||
dateSet(date, dateField, dateValue) Sets an element of a date (e.g. the month) and returns the new date. |