I am doing it like this <cfset
form.dt=#createDate(displayYear,displayMonth,displayDay)#>
-----Original Message-----
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: 09 March 2001 14:36
To: CF-Talk
Subject: RE: find and replace
Yes - probably - I think the error is that that createdate()(or similar) is
not being used when inputing to the database - the output as shown will
output correctly regardless of server locale...
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 09 March 2001 14:21
To: CF-Talk
Subject: RE: find and replace
> For some strange reason our live server is outputting a dateformat of
> #dateformat(dt, 'dd/mm/yy')# as 03/09/01 it should be 09/03/01.
>
> Our development server on the other hand is outputting correctly 09/03/01.
>
> I,ve checked the settings on both servers and I cannot figure out the
> problem.
>
> If anyone has an idea that would be great.
>
> Or else is there a way in CF to break it apart after it has been converted
> to a string,
>
> <cfset dtAsString = ToString(qry_checkSamplerStatus.dt)>
>
> and output the individualy.
Check on the nationalisation of the 2 servers - odds on one is in US and one
is in UK
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
