Date Format in CFCOL

2000-06-20 Thread Paige Chandler 

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/")#
 CFCOL #DateFormat("#Issued_Dat#", "mm/dd/")# 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"
HTMLHEAD
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#ff
DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I'm trying to format a series of dates =
returned=20
from a query, in a table. I've tried:/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2nbsp;lt;CFCOL =
Text=3D#DateFormat("#Issued_Dat#",=20
"mm/dd/")#BRnbsp;lt;CFCOL #DateFormat("#Issued_Dat#", =
"mm/dd/")#=20
Header=3D"Issued"gt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2And several other configurations to no=20
avail./FONT/DIV
DIVFONT face=3DArial size=3D2Does the DateFormat function work on a =
data=20
variable? the books only show it with (NOW)./FONT/DIV
DIVFONT face=3DArial size=3D2
DIVFONT face=3DArial size=3D2Does the DateFormat function work in a =
CFCOL?nbsp;=20
TIA./FONT/DIV
DIVnbsp;/DIV
DIVRegards,/DIV
DIVnbsp;/DIV
DIVPaige/DIV/FONT/DIV
DIVnbsp;/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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Date Format in CFCOL

2000-06-20 Thread Paige Chandler 

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/")#
  CFCOL #DateFormat("#Issued_Dat#", "mm/dd/")# 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"
 HTMLHEAD
 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#ff
 DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2I'm trying to format a series of dates =
 returned=20
 from a query, in a table. I've tried:/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2nbsp;lt;CFCOL =
 Text=3D#DateFormat("#Issued_Dat#",=20
 "mm/dd/")#BRnbsp;lt;CFCOL #DateFormat("#Issued_Dat#", =
 "mm/dd/")#=20
 Header=3D"Issued"gt;/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2And several other configurations to no=20
 avail./FONT/DIV
 DIVFONT face=3DArial size=3D2Does the DateFormat function work on a =
 data=20
 variable? the books only show it with (NOW)./FONT/DIV
 DIVFONT face=3DArial size=3D2
 DIVFONT face=3DArial size=3D2Does the DateFormat function work in a =
 CFCOL?nbsp;=20
 TIA./FONT/DIV
 DIVnbsp;/DIV
 DIVRegards,/DIV
 DIVnbsp;/DIV
 DIVPaige/DIV/FONT/DIV
 DIVnbsp;/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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Date Format in CFCOL

2000-06-20 Thread Brett Payne-Rhodes 

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/")#
   CFCOL #DateFormat("#Issued_Dat#", "mm/dd/")# 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"
  HTMLHEAD
  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#ff
  DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
  DIVnbsp;/DIV
  DIVFONT face=3DArial size=3D2I'm trying to format a series of dates =
  returned=20
  from a query, in a table. I've tried:/FONT/DIV
  DIVnbsp;/DIV
  DIVFONT face=3DArial size=3D2nbsp;lt;CFCOL =
  Text=3D#DateFormat("#Issued_Dat#",=20
  "mm/dd/")#BRnbsp;lt;CFCOL #DateFormat("#Issued_Dat#", =
  "mm/dd/")#=20
  Header=3D"Issued"gt;/FONT/DIV
  DIVnbsp;/DIV
  DIVFONT face=3DArial size=3D2And several other configurations to no=20
  avail./FONT/DIV
  DIVFONT face=3DArial size=3D2Does the DateFormat function work on a =
  data=20
  variable? the books only show it with (NOW)./FONT/DIV
  DIVFONT face=3DArial size=3D2
  DIVFONT face=3DArial size=3D2Does the DateFormat function work in a =
  CFCOL?nbsp;=20
  TIA./FONT/DIV
  DIVnbsp;/DIV
  DIVRegards,/DIV
  DIVnbsp;/DIV
  DIVPaige/DIV/FONT/DIV
  DIVnbsp;/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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Date Format in CFCOL

2000-06-20 Thread Paige Chandler 

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/")#
CFCOL #DateFormat("#Issued_Dat#", "mm/dd/")# 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"
   HTMLHEAD
   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#ff
   DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV
   DIVnbsp;/DIV
   DIVFONT face=3DArial size=3D2I'm trying to format a series of
dates =
   returned=20
   from a query, in a table. I've tried:/FONT/DIV
   DIVnbsp;/DIV
   DIVFONT face=3DArial size=3D2nbsp;lt;CFCOL =
   Text=3D#DateFormat("#Issued_Dat#",=20
   "mm/dd/")#BRnbsp;lt;CFCOL #DateFormat("#Issued_Dat#", =
   "mm/dd/")#=20
   Header=3D"Issued"gt;/FONT/DIV
   DIVnbsp;/DIV
   DIVFONT face=3DArial size=3D2And several other configurations to
no=20
   avail./FONT/DIV
   DIVFONT face=3DArial size=3D2Does the DateFormat function work on
a =
   data=20
   variable? the books only show it with (NOW)./FONT/DIV
   DIVFONT face=3DArial size=3D2
   DIVFONT face=3DArial size=3D2Does the DateFormat function work in
a =
   CFCOL?nbsp;=20
   TIA./FONT/DIV
   DIVnbsp;/DIV
   DIVRegards,/DIV
   DIVnbsp;/DIV
   DIVPaige/DIV/FONT/DIV
   DIVnbsp;/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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.