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.
