Rodney, Oracle accepts the following format "10 JAN 2002" which I like because it removes any potential ambiguity regarding days & months ... which can occur dependant on the locale of Oracle server
----- Original Message ----- From: "COLLINS, Rodney" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, March 27, 2003 5:09 PM Subject: [cfaussie] Date input on Form > Guys, > I have a form that has to accept a date from a user. > > <CFQUERY> then needs to insert FORM.EnteredDateString into an Oracle > database. > > What is the best, or at least accepted, way of doing this. Bearing in mind > that, although prompted with a default of today's date in the correct > format, the user can, and probably will, enter anything, even nothing. Is > there a function, or group of functions, that can make sure a) the date is > defined, b) it is a actually a date, and c) it is read in the Australian > format. > > I seem to be running around in cirlces getting DateFormat etc to do what I > expect them to do, and we are toying with several different ways of doing > this. > > Another problem is that the form contains two dates, one is required, the > other is not. > > Ideas please. > > > Thank you, > > Rod Collins > Business Systems Analyst/Programmer > Information Services Department > BAE SYSTEMS Australia Ltd. > PO Box 1068 Salisbury SA 5108 > AUSTRALIA > Telephone +61 8 8480 7662 > Facsimile +61 8 8480 8866 > Mobile 0414 929 721 > Email: [EMAIL PROTECTED] > > http://www.baesystems.com > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
