Versions Compared

Old Version 4

changes.mady.by.user Fiona Sargeant (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Fiona Sargeant (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

dateSet(date,dateField,dateValue)

 for details about the arguments.dateField
ArgumentParameter TypesDescription
dateDateThe original date or date-time. For the current date-time use the attribute function now().
dateFieldSee Date-Time FunctionsThe element of the date to be be changed, for example the month or seconds.
dateValueThe new value for that date element.

...

Tip

Changing a date-time to a different _DAY_OF_WEEK, always returns a date in the same week as the input date. The week begins on Monday.  For example, if the input date is a Thursday, setting the day of the week to:

  • Monday, Tuesday or Wednesday returns an earlier date
  • Friday, Saturday or Sunday returns a later date.

Examples

ExampleReturns
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".
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
hiddentrue

dateSet(date, dateField, dateValue)   Sets an element of a date (e.g. the month) and returns the new date.

...