Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > R

RDATE

Scroll Prev Top Next More

(RDATE(mon,day,yr))

 

Converts integers mon, day, and yr to a DATE data type. Yr must be a four-digit year. The result returned by RDATE will vary, depending on the DATE format.

 

The following command assigns to the transdate column in the transmaster table the date derived from the values of vmon and vday (integers) as the month and day, and 1995 as the year in rows where the transdate column has a value.

 

UPDATE transmaster SET transdate = (RDATE(.vmon, .vday, 1995)) +

WHERE transdate IS NOT NULL