I am out of the office till wed (was Re: Date fields)

[DRE]

<x-html><div>At 11:46 AM 4/7/2001 -0400, you wrote:</div>
<blockquote type=cite class=cite cite><div>Tim,</div>
<br>
<div>I'm thinking the reason your date is appearing as it is, is due to
your</div>
<div>system's locale -- that format is used in many countries.</div>
<br>
<div>Try the following code to see if it corrects the problem:</div>
<br>
<div>&lt;CFSET SetLocale(&quot;English (US)&quot;&gt;</div>
<div>&lt;CFOUTPUT&gt;#Date#&lt;/CFOUTPUT&gt;</div>
<br>
<div>Dain Anderson</div>
<div>Caretaker, CF Comet</div>
<div><a href="http://www.cfcomet.com/" EUDORA=AUTOURL>http://www.cfcomet.com/</a></div>
<br>
<br>
<br>
<div>----- Original Message -----</div>
<div>From: &quot;Tim Price&quot; &lt;[EMAIL PROTECTED]&gt;</div>
<div>To: &quot;Fusebox&quot; &lt;[EMAIL PROTECTED]&gt;</div>
<div>Sent: Saturday, April 07, 2001 4:17 AM</div>
<div>Subject: Date fields</div>
<br>
<br>
<div>&gt; Could anyone shed any light onto why after entering a date of
&quot;07/04/2001&quot;</div>
<div>&gt; (dd/mm/yyyy format)the following &lt;cfset</div>
<div>&gt;
display_from=#dateformat(display_from,&quot;dd/mm/yyyy&quot;)#&gt;</div>
<div>&gt; switches it to &quot;04/07/2001&quot; (this is only used to
redisplay it if the form</div>
<div>&gt; is redisplayed follwoing validation failure on any form
field)</div>
<div>&gt;</div>
<div>&gt; ..... unless that is I enter a day &gt; 12 and then it retains
its original</div>
<div>&gt; input &quot;13/04/2001&quot;</div>
<div>&gt;</div>
<div>&gt; I also find that if I insert the field into the database
without using</div>
<div>&gt; CreateODBCDate it retains its orginal format but WITH
CreateODBCDate it</div>
<div>&gt; switches the dd/mm parts round if the dd is &lt; 13</div>
<div>&gt;</div>
<div>&gt; Thanx in advance</div>
<div>&gt;</div>
<div>&gt; Tim Price</div>
<div>&gt;</div>
<div>&gt;</div>
<div>&gt;</div>
<div>&gt;</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/fusebox@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists