Dates with century

Hi.
I am pulling dates from an AS400 where the date is formatted as 1050701 for
todays date. CYYMMDD.
I have tried to use the date format for the field (d), but the date does not
change.
Any ideas how I can format this type of date to display as MM/DD/YY.
Thanksi think you'll have to write some custom code to handle the AS400 date format
you're getting. in the cell that is displaying the date you just need
something like this: =code.FormatAsMMDDYY(AS400date)
read about writing custom code in BOL.
"Susan" wrote:
> Hi.
> I am pulling dates from an AS400 where the date is formatted as 1050701 for
> todays date. CYYMMDD.
> I have tried to use the date format for the field (d), but the date does not
> change.
> Any ideas how I can format this type of date to display as MM/DD/YY.
> Thanks