Hi All. I have a file with julian dates that needs to be imported in MS SQL and then convert the dates to gregorian. To extract the year is easy because I just use a left function but how would I get the month and day values? The date I have is 2008001 and I need it to be 2008/01/01. Anyone with any ideas?
