In .com,
DoveArrow spake thusly:

The degree date is stored in Datatel in a mm/yy format. However,
when the web query pulls this data into Excel, it converts it
into a mm/dd format. Example: A student has a degree date of
06/08 (June 2008). When Excel pulls this information, it pulls
it in as 06/08/2007.

What happens if you go to Tools / Options / Error Checking and
turn on error-checking for dates with 2-digit years? I don't
know if this will be helpful or not.

Side Note: In the Edit Web Query screen, where the table should
be, there's nothing displayed. If I had to guess why this should

Not sure, but be sure to try out all the options when you get to
the WebQuery screen and click on the Options icon over at the
top-right. Also look at the settings in Data / Import External Data /
External Data Range Properties. This is with Excel 2002; you didn't
say which version you have.

-dman-