 |
 |
Archives of the TeradataForum
Message Posted: Tue, 18 Jun 2002 @ 19:59:15 GMT
| Subj: | | Re: Microsoft-Access and Teradata |
| |
| From: | | Margaret Westlake |
We also had trouble with Access deciding that our date math should be performed on the PC and not on the Teradata. This resulted
in problems with returning 30 times the data you intended to the PC. Our date math was intended to return only YYYYMM instead of the
full date. Then it seemed that the date math didn't function as expected in Access on the returned data resulting in incorrect
groupings. I think that we fixed it by using SUBSTR on the date (not as efficient, but Access didn't try to do it and let Teradata
handle it). This was several years ago and I haven't tested it since to see if it works right now. I gave up on using Access when I
ran into these problems. (Btw Fred, our missing date for admissions is 1777-07-07 and Excel and Access don't like it either.)
| |
