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

[DRE]

<x-html><div>At 03:14 PM 4/7/2001 +0100, you wrote:</div>
<blockquote type=cite class=cite cite><div>DateFormat() accepts a date
object and, optionally, the format in which you</div>
<div>want to _display_ the date.</div>
<div>If you pass it a string instead of an actual date object then CF
tries to</div>
<div>convert it to a valid date, first using the mm/dd/yyyy format, and
if that</div>
<div>fails it tries dd/mm/yyyy.</div>
<div>IsDate() does the same sort of thing, and so do some
databases...</div>
<br>
<div>If you get a date passed as a string (eg from a form), then the
_first_</div>
<div>thing you should do IMHO is use CreateDate() to turn it into a date
object.</div>
<br>
<div>And only use DateFormat() when you're displaying a date and not to
set a</div>
<div>variable, because you then run the risk of that variable being
used</div>
<div>incorrectly elsewhere by someone who doesn't know what format mask
you used</div>
<div>when you created the string.</div>
<br>
<div>ie </div>
<div>good: &lt;cfset mydateobject =</div>
<div>CreateDate(ListLast(form.date,'/'),ListGetAt(form.date,2,'/'),ListFirst(form</div>
<div>..date,'/')&gt;</div>
<div>good: #DateFormat(mydateobject, 'dd/mm/yyyy')#&nbsp;&nbsp;&nbsp;
</div>
<div>risky: &lt;cfset mydate = DateFormat(mydateobject,
'dd/mm/yyyy')&gt;</div>
<div>bad: &lt;cfset mydateobject =
CreateDate(form.date,'dd/mm/yyyy')&gt;</div>
<div>bad: IsDate(form.date)</div>
<br>
<div>Bert</div>
<br>
<div>Certified CF Developer who spent a lot of time tidying up shoddy
date</div>
<div>handling written by someone else...</div>
<br>
<div>&gt; -----Original Message-----</div>
<div>&gt; From: Tim Price
[<a href="mailto:[EMAIL PROTECTED]" 
EUDORA=AUTOURL>mailto:[EMAIL PROTECTED]</a>]</div>
<div>&gt; Sent: 07 April 2001 09:17</div>
<div>&gt; To: Fusebox</div>
<div>&gt; Subject: Date fields</div>
<div>&gt; </div>
<div>&gt; </div>
<div>&gt; Could anyone shed any light onto why after entering a date of
</div>
<div>&gt; &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 </div>
<div>&gt; 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
</div>
<div>&gt; 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 </div>
<div>&gt; 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