Thanks, I did some more research and Microsft Access converts any time/date conversion to a Julian Date which is the number of days since 12/1/1889 starting with 0.00 being the first minute. I finally just gave up using the date and was able to achieve the same task using an integer number. I was trying to set a primary key for the database and the date would have been an obvious one. The integer number works fine for me so I don't even need to mess with the date. Ali -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Handby Sent: Tuesday, September 06, 2005 12:26 AM To: [email protected] Subject: RE: [AspNetAnyQuestionIsOk] Weird Date Issue with MS Access Hi Ali,
> Follow up to this email. when I checked to see what the actual sql was > doing it was: > > INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/5/2005, > 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) I think Access is interpreting your dates as arithmetic expressions, then converting the result of the expression into a string to store in the database. If you work out 8 / 5 / 2005 with a calculator (8 divided by 5, divided by 2005) you'll see what I mean! Jason _____ YAHOO! GROUPS LINKS * Visit your group "AspNetAnyQuestionIsOk <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] cribe> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
