Ok if I just output qry_checkSamplerStatus.dt
<cfoutput query="dt>#dt#</cfoutput>
I get
2001-03-09 00:00:00
If I try
<cfset condertdt = dateFormat(qry_checkSamplerStatus.dt, 'mmmm - dddd -
yyyy')>
I get
September - Monday - 2001
<cfset dt = dateformat(qry_checkSamplerStatus.dt, 'dddd - mmmm - yyyy')>
I get
Monday - September - 2001
or else if I try
2001 - September - Monday
-----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
