Tim,

I'm thinking the reason your date is appearing as it is, is due to your
system's locale -- that format is used in many countries.

Try the following code to see if it corrects the problem:

<CFSET SetLocale("English (US)">
<CFOUTPUT>#Date#</CFOUTPUT>

Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/



----- 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

Reply via email to