I've had so much grief with dates and Access databases and IIS webservers...
the only way I've consistantly survived this (mmddyy Vs ddmmyy) is to use
the ISO date format when reading and writing dates to a database.
Every database worth it's salt can process the ISO format, which is
yyyy/mm/dd
my 2C worth
barry.b
-----Original Message-----
From: COLLINS, Rodney [mailto:[EMAIL PROTECTED]
Sent: Thursday, 27 March 2003 4:10 PM
To: CFAussie Mailing List
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/
