Jumat, 22 April 2016

[MS_AccessPros] pass through queries converting dates


Pros, is there a function I’m missing to convert a date in a passthrough query?


I’m dealing with JDE dates in the format CYYDDD and have written a function to translate it, but I think if the SQL Server could handle it I could gain considerable speed.


I’m trying Date(fieldname,CYDDD) but that gives me an odbc error.



Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments


1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808


Passion to Innovate. Power to Deliver


This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!



Tidak ada komentar:

Posting Komentar