I agree - the way they want these dates given to them seems very outdated.

>
>We stopped using Julian dates here before 2000 as they were not Y2K compliant. YYXXX does not sort very well and we recommended they either expand it to be YYYYXXX or just convert the field to a regular date field and use date math to do any computing they would require. Same way we had to redesign all the government use of FY (fiscal Year). Usually in the form FY99, FY01, FY02. So you can see they dont sort very well either.