 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2006Converting a date
I have an input field which allows an input of DD/MM/YYYY, this then goes into a VBA SQL query which converts the inputted numbers to MM/DD/YYYY. How do I stop this? Cheers Nick Hi, perhaps you trying to convert it to date type? try to operate with it like a string  SignatureAlex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com >I have an input field which allows an input of DD/MM/YYYY, this then goes > into a VBA SQL query which converts the inputted numbers to MM/DD/YYYY. > > How do I stop this? > > Cheers Nick I need it to be a date type as the fields it is referencing are date type fields. Cheers Nick > Hi, > perhaps you trying to convert it to date type? [quoted text clipped - 6 lines] > > > > Cheers Nick Regardless of what your Regional Settings may be set to, Access expects mm/dd/yyyy format in SQL statements. Simply explicitly format the input, using Format([MyValue], "\#mm\/dd\/yyyy\#") You might find it useful to read Allen Browne's "International Dates in Access" at http://allenbrowne.com/ser-36.html or what I had in my September 2003 "Access Answers" column for Pinnacle Publication's "Smart Access" newsletter. (The column and accompanying database can be downloaded for free at http://www.accessmvp.com/djsteele/SmartAccess.html) SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > I have an input field which allows an input of DD/MM/YYYY, this then goes > into a VBA SQL query which converts the inputted numbers to MM/DD/YYYY. > > How do I stop this? > > Cheers Nick Thanks, that has worked a treat > Regardless of what your Regional Settings may be set to, Access expects > mm/dd/yyyy format in SQL statements. Simply explicitly format the input, [quoted text clipped - 12 lines] > > > > Cheers Nick |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.