date default error after 1999
Date formats work correctly in the 21st century. That's not your problem. I
suspect you have the wrong underlying date. Display your date in full using
mm/dd/yyyy, so you can make sure it's correct.
--
Regards,
Fred
"Mollyb" wrote in message
...
Date format mmm-yy changes entries to mmm-06 for any date after 1999, as does
month-yy and m-yy. All dates prior to 12/31/99 work correctly in these three
formats. All other date formats work correctly. Is a setting off
somewhere?
|