Julian date and time functions

Date and Time fields.

  • !DATE specifies the field has one of the date formats dd/mm/yy, dd/mm/ccyy, dd-Mon-yy or dd-Mon-ccyy and is to be converted into a Julian day dd is a 1 or 2 digit day of the month, mm a 1 or 2 digit month of the year, Mon is a three letter month name ( Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ), yy is the year within the century (00 to 99), cc is the century (19 or 20). The separators '/' and '-' must be present as indicated. The dates are converted to days since 1899. When the century is not specified, yy of 0-32 is taken as 2000-2032, 33-99 taken as 1933-1999.
  • !DMY specifies the field has one of the date formats dd/mm/yy or dd/mm/ccyy and is to be converted into a Julian day.
  • !MDY the field has one of the date formats mm/dd/yy or mm/dd/ccyy and is to be converted into a Julian day.
  • !TIME specifies the field has one of the format hh:mm:ss and is to be converted into seconds past midnight where hh is hours (0 to 23), mm is minutes (0-59) and ss is seconds (0 to 59). The separator ':' must be present as indicated.

    Converting numeric date fields.

    preceeding qualifiers apply when the date fields have separators '/' or '-' in them. These qualifiers apply when are no separators in the date field.
  • !Jddm converts a number presumed to be a date in the form ddmmccyy, ddmmyy or ddmm into days.
  • !Jmmd converts a date in the form ccyymmdd, yymmdd or mmdd into days.
  • !Jyyd converts a date in the form ccyyddd or yyddd into days.

    These calculate the number of days since December 31 1899 and are valid for dates from January 1 1900 to December 31 2099; note that if cc is omitted it is taken as 19 if yy lt 33 and 20 if yy gt 32. The date string must be entirely numeric: characters such as '/' may not be present.
  • Back to transformation summary

    Return to index