ToGregorianDate

Converts the specified Julian Date to the corresponding or Gregorian date format. Julian Date is a date format that is a combination of the current year and the number of days since the beginning of the year. It is is a 6 digit number, consisting of a digit era, 2 digit year and a 3 digit day-of-year number.

Syntax

ToGregorianDate(scalar JulianDate)

Arguments

Argument	Description
scalar JulianDate	Julian date to be converted to Gregorian Date/ Calendar Date

Examples:

ToGregorianDate('091248')

Returns the calendar or Gregorian date format corresponds to the specified Julian Date.