RndFormatDate Function

Action

Adds a random number of days between 0 and nDays to a date and formats this date into the specified format. The random values generated are distributed uniformly.

Include file

Kernel.bdh

Syntax

RndFormatDate( in nDate      : number,
               in nDays      : number,
               in sFormat    : string,
               in bLocalized : boolean optional ): string;

Return value

formatted date string

Parameter Description
nDate Input date with format YYYYMMDD
nDays Upper boundary of random interval for days to add
sFormat Format control string (see FormatDate)
bLocalized If True, returns the localized date format (optional).

Example

dcltrans
  transaction TRndFormatDate
  var
    sNewDate: string;
  begin
    // add 0 - 20 days to 19961015 and format it to "1996-11-10"
    sNewDate := RndFormatDate(19961015, 20, DATE_YYYY_MM_DD);
    write("newdate = "); write(sNewDate); writeln;
  end TRndFormatDate;

Output

newdate = 1996-10-30

Sample scripts

OraSample.bdf, DBApi01.bdf