Otherwise instead of using the query attribute of cfgrid
Loop over cfgridrow tag like
<cfloop query=q>
<cfgridrow data="#Fullname#,#dateformat(now(),"dd / mm / YY")#">
</cfloop>
Hope that helps
~JustinMacCarthy
Coming soon WWW.CFFAQ.ORG
----- Original Message -----
From: Justin MacCarthy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 17, 2000 1:28 PM
Subject: Re: formating date in CFGRID
> 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.
>
>
------------------------------------------------------------------------------
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.
