Forum Discussion
Resolver I7digit Julian to Date provides incorrect date
The code from the blog that you tried is, I believe, using a different definition of Julian date than you are. Some define Julian date as the Gregorian Date in the format of yyyyddd where "ddd" is the day number of the year. So 2-Jan-2020 would be 2020002 in that system.
See this article on Julian Day Numbers by Peter Meyer for more information than you really need. I would think a simple subtraction should work.
Awesome! Thanks Ron
Resolver INot sure if this is right....but I'm using the following code and it seems to give the correct date. The hard coded number is the starting point for oracle julian dates.
Date.From([J-Date]-2415018.5))
Any concerns that could cause errors doing it this way?
ronrsnfldSuper User
The code from the blog that you tried is, I believe, using a different definition of Julian date than you are. Some define Julian date as the Gregorian Date in the format of yyyyddd where "ddd" is the day number of the year. So 2-Jan-2020 would be 2020002 in that system.
See this article on Julian Day Numbers by Peter Meyer for more information than you really need. I would think a simple subtraction should work.
- codyraptor
Awesome! Thanks Ron