--------------106E292EBC4B30F10F8DC269
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I had the same problem with FoxPro 2.0 data. The workaround I came up with was to not
display dates older than 1901:
<cfif year(followup) gt 1901>#DateFormat(followup,'dd-mm-yyyy')#</cfif>
I was displaying the date field directly, not using CFGrid, so your milage may vary...
- Michael Smith, TeraTech http://www.cfconf.org/
MDCFUG http://www.cfug-md.org/
Paige Chandler wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0009_01BFE76E.D7462320
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi All,
>
> I'm "Selecting * From..." using a Visual FoxPro free table. Some of the =
> date fields (VFP date format) are blank. When displayed with CFTable or =
> CFGridCol they appear "1899-12-30". I must resolve this. Any =
> suggestions? TIA.
>
> Regards,
>
> Paige
>
> ------=_NextPart_000_0009_01BFE76E.D7462320
> 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 "Selecting * From..." using a =
> Visual FoxPro=20
> free table. Some of the date fields (VFP date format) are blank. When =
> displayed=20
> with CFTable or CFGridCol they appear "1899-12-30". I must resolve this. =
> Any=20
> suggestions? TIA.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Paige</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0009_01BFE76E.D7462320--
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> 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.
--
Michael Smith, TeraTech Inc - Tools for Programmers(tm)
VB, CF/ASP Web, Telephony, Math, Access programming tools & consulting
100 Park Ave Ste 360, Rockville MD 20850 USA
Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185 BBS:301-762-8184
Web: http://www.teratech.com/sig/
Email: mailto:[EMAIL PROTECTED]
--------------106E292EBC4B30F10F8DC269
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
I had the same problem with FoxPro 2.0 data. The workaround I came up with
was to not display dates older than 1901:
<p> <cfif year(followup) gt
1901>#DateFormat(followup,'dd-mm-yyyy')#</cfif>
<br>I was displaying the date field directly, not using CFGrid, so your
milage may vary...
<p>- Michael Smith, TeraTech <A
HREF="http://www.cfconf.org/">http://www.cfconf.org/</A>
<br>
MDCFUG <A HREF="http://www.cfug-md.org/">http://www.cfug-md.org/</A>
<p>Paige Chandler wrote:
<blockquote TYPE=CITE>This is a multi-part message in MIME format.
<p>------=_NextPart_000_0009_01BFE76E.D7462320
<br>Content-Type: text/plain;
<br> charset="iso-8859-1"
<br>Content-Transfer-Encoding: quoted-printable
<p>Hi All,
<p>I'm "Selecting * From..." using a Visual FoxPro free table. Some of
the =
<br>date fields (VFP date format) are blank. When displayed with CFTable
or =
<br>CFGridCol they appear "1899-12-30". I must resolve this. Any =
<br>suggestions? TIA.
<p>Regards,
<p>Paige
<p>------=_NextPart_000_0009_01BFE76E.D7462320
<br>Content-Type: text/html;
<br> charset="iso-8859-1"
<br>Content-Transfer-Encoding: quoted-printable
<p><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<br><HTML><HEAD>
<br><META content=3D"text/html; charset=3Diso-8859-1" =
<br>http-equiv=3DContent-Type>
<br><META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<br><STYLE></STYLE>
<br></HEAD>
<br><BODY bgColor=3D#ffffff>
<br><DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV>
<br><DIV>&nbsp;</DIV>
<br><DIV><FONT face=3DArial size=3D2>I'm "Selecting * From..." using
a =
<br>Visual FoxPro=20
<br>free table. Some of the date fields (VFP date format) are blank. When
=
<br>displayed=20
<br>with CFTable or CFGridCol they appear "1899-12-30". I must resolve
this. =
<br>Any=20
<br>suggestions? TIA.</FONT></DIV>
<br><DIV>&nbsp;</DIV>
<br><DIV><FONT face=3DArial size=3D2>Regards,</FONT></DIV>
<br><DIV>&nbsp;</DIV>
<br><DIV><FONT face=3DArial size=3D2>Paige</FONT></DIV></BODY></HTML>
<p>------=_NextPart_000_0009_01BFE76E.D7462320--
<p>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.mail-archive.com/[email protected]/">http://www.mail-archive.com/[email protected]/</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
<p>--
<br>Michael Smith, TeraTech Inc - Tools for Programmers(tm)
<br>VB, CF/ASP Web, Telephony, Math, Access programming tools & consulting
<br>100 Park Ave Ste 360, Rockville MD 20850 USA
<br>Voice: +1-301-424-3903, 800-447-9120 x500 Fax:301-762-8185
BBS:301-762-8184
<br>Web: <A HREF="http://www.teratech.com/sig/">http://www.teratech.com/sig/</A>
<br>Email: <A HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>
<br> </html>
--------------106E292EBC4B30F10F8DC269--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
