x

DATEMOV(date, 'move-point')

where:

date

Date

Is the date to be moved. It must be a full component format date (for example, MDYY or YYJUL).

move-point

Alphanumeric

Is the significant point the date is moved to. An invalid point results in a return code of zero. Valid values are:

'EOM' is the end of month.

'BOM' is the beginning of month.

'EOQ' is the end of quarter.

'BOQ' is the beginning of quarter.

'EOY' is the end of year.

'BOY' is the beginning of year.

'EOW' is the end of week.

'BOW' is the beginning of week.

'NWD' is the next weekday.

'NBD' is the next business day.

'PWD' is the prior weekday.

'PBD' is the prior business day.

'WD-' is a weekday or earlier.

'BD-' is a business day or earlier.

'WD+' is a weekday or later.

'BD+' is a business day or later.

A business day calculation is affected by the BUSDAYS and HDAY parameter settings.

Note: DATEMOV does not use an output_format; it uses the format of the argument date for the result. As long as the result is a full component date, it can be assigned only to a full component date field or to an integer field.

Top of page

Example: Moving a Date to a Significant Point

This example finds the end day of the current date week

DATEDIF('&YYMD', 'EOW')

and returns 20040326 if today is 2004, March 23rd. Note the use of the system variable &YYMD and natural date representation in the first argument.