The default date format for your locale is the typical month / day / year.
Thats why its switching the day and month around (except when you have 13 or
higher in the first list position, sinse there are only 12 months).
Easiest solution would be to use a seperate form field for each month/ day /
year and then reassemble them in the order you want. Or start looking at
how use getlocale() setlocale()
Fred
----- Original Message -----
From: "Tim Price" <[EMAIL PROTECTED]>
To: "Fusebox" <[EMAIL PROTECTED]>
Sent: Saturday, April 07, 2001 4:17 AM
Subject: Date fields
> Could anyone shed any light onto why after entering a date of "07/04/2001"
> (dd/mm/yyyy format)the following <cfset
> display_from=#dateformat(display_from,"dd/mm/yyyy")#>
> switches it to "04/07/2001" (this is only used to redisplay it if the form
> is redisplayed follwoing validation failure on any form field)
>
> ..... unless that is I enter a day > 12 and then it retains its original
> input "13/04/2001"
>
> I also find that if I insert the field into the database without using
> CreateODBCDate it retains its orginal format but WITH CreateODBCDate it
> switches the dd/mm parts round if the dd is < 13
>
> Thanx in advance
>
> Tim Price
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
