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

Tue, 10 Apr 2001 08:25:46 -0700 

<x-html><div>At 12:26 PM 4/7/2001 -0400, you wrote:</div>
<blockquote type=cite class=cite cite><div>The default date format for
your locale is the typical month / day / year.</div>
<div>Thats why its switching the day and month around (except when you
have 13 or</div>
<div>higher in the first list position, sinse there are only 12
months).</div>
<br>
<div>Easiest solution would be to use a seperate form field for each
month/ day /</div>
<div>year and then reassemble them in the order you want.&nbsp; Or start
looking at</div>
<div>how use getlocale() setlocale()</div>
<br>
<div>Fred</div>
<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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to