Hi Brett,
You think very well. It works fine now. Thank you very much. By the way VFP
is short for Visual FoxPro as VB is short for Visual Basic..
Have a nice day.
Regards,
Paige
----- Original Message -----
From: Brett Payne-Rhodes <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 20, 2000 9:27 PM
Subject: Re: Date Format in CFCOL
> 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.
>
------------------------------------------------------------------------------
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.
