find julian days from a date which is in format mm/dd/yy

[sridharvis]

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.

[ray.wurlod]

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"