I'm playing around with the date() function and am trying to convert a date in the format yyddd to yymmdd but I can't find a way to handle the yy portion of the date. The "D" option supports the ddd portion but the result shows the current year. How can I make yy be part of the calculation?

Staffan