<x-html><div>At 06:38 AM 4/7/2001 -0400, you wrote:</div>
<blockquote type=cite class=cite cite><div>While this question is better
suited for another forum, you are saying that</div>
<div>(keeping it simple) if you did:</div>
<br>
<div><cfset display_from = "07/04/2001"></div>
<div><cfset display_from = dateformat(display_from,
"mm/dd/yyyy")></div>
<div><cfoutput></div>
<div><x-tab> </x-tab>#display_from#</div>
<div></cfoutput></div>
<br>
<div>that you would get:</div>
<br>
<div>04/07/2001</div>
<br>
<div>? Should not be possible with the information you have
provided. Just</div>
<div>tested it to be sure, but there is nothing all that unusual or
complex about</div>
<div>what you say you are doing. Guess we need more
information. Do you enter</div>
<div>the date as straight text in a text input on a form or are using a
custom</div>
<div>tag of some sort to help validate data? Need more
data.</div>
<br>
<div>On the database issues, it would be helpful to know what database
because if</div>
<div>its Access, I have found CreateODBCDate to provide incorrect
results. If</div>
<div>you want to keep this off fusebox mailing, e-mail me direct if you
would</div>
<div>like.</div>
<br>
<div>Mike Craig</div>
<div>[EMAIL PROTECTED]</div>
<div>FuseboxWorld</div>
<br>
<div>-----Original Message-----</div>
<div>From: Tim Price
[<a href="mailto:[EMAIL PROTECTED]"
EUDORA=AUTOURL>mailto:[EMAIL PROTECTED]</a>]</div>
<div>Sent: Saturday, April 07, 2001 4:17 AM</div>
<div>To: Fusebox</div>
<div>Subject: Date fields</div>
<br>
<br>
<div>Could anyone shed any light onto why after entering a date of
"07/04/2001"</div>
<div>(dd/mm/yyyy format)the following <cfset</div>
<div>display_from=#dateformat(display_from,"dd/mm/yyyy")#></div>
<div>switches it to "04/07/2001" (this is only used to
redisplay it if the form</div>
<div>is redisplayed follwoing validation failure on any form
field)</div>
<br>
<div>...... unless that is I enter a day > 12 and then it retains its
original</div>
<div>input "13/04/2001"</div>
<br>
<div>I also find that if I insert the field into the database without
using</div>
<div>CreateODBCDate it retains its orginal format but WITH CreateODBCDate
it</div>
<div>switches the dd/mm parts round if the dd is < 13</div>
<br>
<div>Thanx in advance</div>
<br>
<div>Tim Price</div>
<div>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
