I would like to convert date which is in mm/dd/yy to Julian day
I had done JulianDayFromDate(StringToDate('06/24/13',"%mm/%dd/%yy")) and i got the result "2419942", which is equivalent to 1913-06-23. But i would want the output to be "2456467", which is equivalent to 2013-06-23.
find julian days from a date which is in format mm/dd/yy
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 26
- Joined: Thu Apr 17, 2008 1:38 pm
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Change your date format string or your CENTURYPIVOT setting so that two digit years don't default to the twentieth century. Perhaps
Code: Select all
"%mm/%dd/%20yy"
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.