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
