D
DoveArrow
I work in a Registrar's Office for a private university. Recently our
office purchased some software that creates web queries from
information that we have stored in a database, called Datatel. The
problem is, it's not pulling degree dates correctly. Here's what's
happening:
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.
Now I've tried disabling the date recognition option in the Edit Web
Query screen and that works fine, so long as I have the report open
and I don't save it. If I try to save and close out, however, the
report won't function the next time I open it. Is there a way to make
the date pull correctly without causing my report to stop working?
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 be, I
would say that it's because the web query is somehow creating a
temporary website whenever it's opened. I'm also guessing that when I
change the options and save them, it somehow loses the information it
used to create the temporary website in the first place, which is why
my report won't function anymore when I open it again.
office purchased some software that creates web queries from
information that we have stored in a database, called Datatel. The
problem is, it's not pulling degree dates correctly. Here's what's
happening:
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.
Now I've tried disabling the date recognition option in the Edit Web
Query screen and that works fine, so long as I have the report open
and I don't save it. If I try to save and close out, however, the
report won't function the next time I open it. Is there a way to make
the date pull correctly without causing my report to stop working?
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 be, I
would say that it's because the web query is somehow creating a
temporary website whenever it's opened. I'm also guessing that when I
change the options and save them, it somehow loses the information it
used to create the temporary website in the first place, which is why
my report won't function anymore when I open it again.