DSXchange

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.

Change your date format string or your CENTURYPIVOT setting so that two digit years don't default to the twentieth century. Perhaps