I presume form.festdate is a text field?
The most reliable way of capturing dates correctly on a form is to have 3
select boxes, (day/month/year) with appropiate values in each one.
Then when the user submits use createdate(form.year,form.month,form.day) to
create an unambiguous (is that a word) date stamp.
Its normally a good idea to put that in <cftry>/<cfcatch> to catch invalid
dates entered (e.g. 30/02/01)
If you use createodbcdate() on that, then the data in db is correct.
You can then use dateformat() to display it how you want...
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 20 April 2001 11:47
To: CF-Talk
Subject: FW: Dates suddenly formatting incorrectly.
Hi all,
Strange one this, it has me totally perplexed on this Friday morning.
I have several sites which have events pages. The site admin can upload
details of new events, including their dates. This all worked fine until
yesterday, when two of them started acting strangely, like so:
User inputs date: 26/05/01
Date as shown in Access2000: 01/05/26
For some reason it seems to be swapping around the day and year. The date
field is a short date.
This is the code for uploading the date:
<cfif IsDefined("Form.festdate")>
<cfset festdate = #CreateODBCDate(Form.festdate)#>
</cfif>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<cfquery name="addfest" datasource="#datasourcename#">
INSERT INTO tblfestticks (production, festdate, notes)
VALUES (#Form.production#, #festdate#, '#Form.notes#');
</cfquery>
So, I tried changing the date line to this:
<cfset festdate = #CreateODBCDate(#DateFormat("#Form.festdate#",
"dd/mm/yy")#)#>
and the date 26/05/01 became 05/01/26!!
Now I'm really confused, and whilst I'm sure one of you guys will take one
look at this and sort it out, I am completely stumped.
Regards,
Will Swain
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
