your date (09/03/01) is in fact september 3 2001. So you can format it the
way you want, you will always get september 3rd 2001.
If you want today's date... you need to have 03/09/2001 in your database.
If you want a european date format, you will then have to reformat it using
#DateFormat(dt,'dd/mm/yy')#
You are inserting the wrong date in your database. If this is a user entry
field, you can either use a CFINPUT and validate a eurodate, or you will
have to reconstruct the date element before doing your insert.
O-
----- Original Message -----
From: "John McCosker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 09, 2001 11:00 AM
Subject: RE: find and replace
> Ok this is whats happening,
>
> If I try
> <cfoutput query="qry_checkSamplerStatus">#dt#</cfoutput>
>
> I get
> dvelopment server
>
> 09/03/01 00:00:00
>
> if I try
> <cfset dt = qry_checkSamplerStatus.dt>
> <cfset convertdt = dateformat(dt, "dddd - mmmm - yyyy")>
>
> I get
>
> Monday - September - 2001
>
> else if I try
>
> <cfset dt = dateformat(qry_checkSamplerStatus.dt, 'yyyy - mmmm - dddd')>
> I get
> <cfoutput>#dt#</cfoutput>
> 2001 - September - Monday
>
> else if I try
>
> <cfset dt = dateformat(qry_checkSamplerStatus.dt, 'dddd - mmmm - yyyy')>
> <cfoutput>#dt#</cfoutput>
> Monday - September - 2001
>
> else if I try
>
> <cfset dt = dateformat(qry_checkSamplerStatus.dt, 'mmmm - dddd - yyyy')>
> <cfoutput>#dt#</cfoutput>
> September - Monday - 2001
>
>
> weird or what, I am never going to get the correct date unless I do the
> first option
>
> -----Original Message-----
> From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
> Sent: 09 March 2001 14:33
> To: CF-Talk
> Subject: RE: find and replace
>
>
> UK!!!!
>
> In the uk we present dates as d/m/y - (which makes sense, as it goes from
> least significant to most significant) rather than US which goes Medium,
> Small, Large (m/d/y) for some unexplicable and confusing reason (at least
to
> all UK residents...)
>
> -----Original Message-----
> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> Sent: 09 March 2001 14:18
> To: CF-Talk
> Subject: Re: find and replace
>
>
> If this is how it is on your live server: #dateformat(dt, 'dd/mm/yy')# as
> 03/09/01, then the way it is formatting is correct. Change the format to
> DateFormat(dt,"mm/dd/yy") and it should be correct. Otherwise, I would
> output your date without formatting and see what it looks like. Then I
would
> play with the formatting to get the desired results.
>
> HTH
>
> --
> Clint Tredway
> www.factorxsoftware.com
> --
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
