Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > J

JDATE

Scroll Prev Top Next More

(JDATE(arg))

 

Where arg is a value that has a DATE or DATETIME data type, JDATE returns the Julian date of the date in the form YYYYDDD. This is a change from versions prior to R:BASE 6.1a which returned a value in the format YYDDD. This two digit year format was incompatible with the year 2000 and may require altering database structure or program code.

 

In the following example, the value of vjdate is 1995163. The year is 1995, and 163 means that the date is the 163rd day of 1995.

 

SET VAR vjdate = (JDATE('06/12/95'))