How do I convert a ddate toJulian format?

[Former Member]

Need to take a mm/dd/yy date and convert it to Julian. Example 02/26/10 becones 10051 (51st day of 2010)

[Former Member · Accepted solution]

Isn't 02/26/10 the 57th day of 2010?

totext(year(x),"00") & totext(datediff('d',date(year(x),01,01),x)+1,"000");
// where X is the date field and assuming that the year is two digits, otherwise
totext(year(x),0,'','')[3 to 4] & totext(datediff('d',date(year(x),01,01),x)+1,"000");

Edited by: Sanjay Kodidine on May 25, 2010 1:19 PM