This email is to be read subject to the disclaimer below.
Hi Rodney,
How about using three form fields, one for the day, one for the month, one
for the year? That would make parsing the date easier don't you think?
Just a thought...
Viktor Radnai
Web Developer, National E-Commerce, Ernst & Young
Direct: +61 2 9248 4361
"COLLINS, Rodney"
<[EMAIL PROTECTED] To: "CFAussie Mailing List" <[EMAIL
PROTECTED]>
> cc:
Sent by: Subject: [cfaussie] Date
input on Form
[EMAIL PROTECTED]
mon.com.au
27/03/2003 05:09 PM
Please respond to "CFAussie
Mailing List"
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/
--------------------
NOTICE - This communication contains information which is confidential and
the copyright of Ernst & Young or a third party.
If you are not the intended recipient of this communication please delete
and destroy all copies and telephone Ernst & Young on 1800 655 717
immediately. If you are the intended recipient of this communication you
should not copy, disclose or distribute this communication without the
authority of Ernst & Young.
Any views expressed in this Communication are those of the individual
sender, except where the sender specifically states them to be the views of
Ernst & Young.
Except as required at law, Ernst & Young does not represent, warrant and/or
guarantee that the integrity of this communication has been maintained nor
that the communication is free of errors, virus, interception or
interference.
Liability limited by the Accountants Scheme, approved under the
Professional Standards Act 1994 (NSW)
--------------------
---
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/
