How to convert date into dd/mm/yy?

[vkunirs]

Hi

i am reading an email. it is haivng date in this format.

"Wed, 20 Apr 2005 18:37:17 +0530"

now when i am dispalying this date i want to display it in the dd-mm-yyyy
format.

how to do it?

[gclausen]

Have you tried the DateFormat() function? DateFormat( yourDate, "dd-mm-yyyy") [url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi59.htm[/url]

[vkunirs]

Hi

yeap...
but i not getting with that.

[PaulH]

please show your code. what locale is your cf server using?

[OldCFer]

Try:

<cfset dt = "Wed, 20 Apr 2005 18:37:17 +0530">
<cfoutput>#DateFormat(ParseDateTime(dt),"dd-mm-yyyy")#</cfoutput>

[PaulH]

under mx 7, i was able to dump in that string into dateFormat just fine though my first thought was also to use parseDateTime.

[Unregistered]

<CFQuery name='getlist' Datasource="AS400" >
SELECT
ITEMMAST.AS400DATE),5,8) || '-' || Substring(Digits(HHHLIB.ITEMMAST.AS400DATE),3,2) || '-' || Substring(Digits(HHHLIB.ITEMMAST.AS400DATE),1,2)) As SQLDATE

FROM ITEMMAST

</CFQUERY>
<CFQUERY NAME='GET2' DATASOURCE='getlist' dbtype='query'>
WHERE
SQLDATE >#CreateODBCDate( now())#
</CFQUERY>