I don't know what 'VFP' means but did you take of the quotes as well? If
you didn't the dateFormat function thinks it is a string (I think).
Brett.
Paige Chandler wrote:
>
> Hi Alex,
>
> Thanks. That worked - but the Issued_Dat is a VFP date field and now my
> error is that it must be a date/time format. Any more advice? TIA.
>
> Regards,
>
> Paige
>
> ----- Original Message -----
> From: Sicular, Alexander <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 20, 2000 5:45 PM
> Subject: RE: Date Format in CFCOL
>
> > take off the pounds from issued_date
> >
> > -Alex
> >
> > -----Original Message-----
> > From: Paige Chandler [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, June 20, 2000 5:33 PM
> > To: [EMAIL PROTECTED]
> > Subject: Date Format in CFCOL
> >
> >
> > This is a multi-part message in MIME format.
> >
> > ------=_NextPart_000_000C_01BFDADD.8D05AC10
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hi All,
> >
> > I'm trying to format a series of dates returned from a query, in a =
> > table. I've tried:
> >
> > <CFCOL Text=3D#DateFormat("#Issued_Dat#", "mm/dd/yyyy")#
> > <CFCOL #DateFormat("#Issued_Dat#", "mm/dd/yyyy")# Header=3D"Issued">
> >
> > And several other configurations to no avail.
> > Does the DateFormat function work on a data variable? the books only =
> > show it with (NOW).
> > Does the DateFormat function work in a CFCOL? TIA.
> >
> > Regards,
> >
> > Paige
> >
> >
> > ------=_NextPart_000_000C_01BFDADD.8D05AC10
> > 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=3Diso-8859-1" =
> > 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>Hi All,</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>I'm trying to format a series of dates =
> > returned=20
> > from a query, in a table. I've tried:</FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2> <CFCOL =
> > Text=3D#DateFormat("#Issued_Dat#",=20
> > "mm/dd/yyyy")#<BR> <CFCOL #DateFormat("#Issued_Dat#", =
> > "mm/dd/yyyy")#=20
> > Header=3D"Issued"></FONT></DIV>
> > <DIV> </DIV>
> > <DIV><FONT face=3DArial size=3D2>And several other configurations to no=20
> > avail.</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>Does the DateFormat function work on a =
> > data=20
> > variable? the books only show it with (NOW).</FONT></DIV>
> > <DIV><FONT face=3DArial size=3D2>
> > <DIV><FONT face=3DArial size=3D2>Does the DateFormat function work in a =
> > CFCOL? =20
> > TIA.</FONT></DIV>
> > <DIV> </DIV>
> > <DIV>Regards,</DIV>
> > <DIV> </DIV>
> > <DIV>Paige</DIV></FONT></DIV>
> > <DIV> </DIV></BODY></HTML>
> >
> > ------=_NextPart_000_000C_01BFDADD.8D05AC10--
> >
> > --------------------------------------------------------------------------
> --
> > --
> > 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.
------------------------------------------------------------------------------
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.
