You chould try using SQL again something like
SELECT CONVERT(varchar, Day(GETDATE()))
+ '/' + CONVERT(varchar, MONTH(GETDATE()))
+ '/' + CONVERT(varchar, YEAR(GETDATE())) AS MyDate
What are the issues with cfgrid????
~JustinMacCarthy
Coming soon WWW.CFFAQ.ORG
----- Original Message -----
From: Dharmendar Kumar <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 17, 2000 11:24 AM
Subject: formating date in CFGRID
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0046_01BFC018.3A7D46E0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Does anyone know how to format dates in CFGRID. "DateFormat" is not =
> working.
>
> Dharmendar Kumar
>
> ------=_NextPart_000_0046_01BFC018.3A7D46E0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Dwindows-1252" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Does anyone know how to format dates in =
>
> CFGRID. "DateFormat" is not working.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Dharmendar =
> Kumar</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0046_01BFC018.3A7D46E0--
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
