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/
