Hi Michael,
Thanks for the suggestion. This is very bad news. My app displays the status
of a list of insurance policies for a particular piece of property: Date
Issued, Date Canceled, Date Expired. Most of the time the last two are
blank. And there may be from 1 to 9 policies listed for a property: General
Liability, Auto, Umbrella, etc. I don't believe that I can insert CFIF tags
within CFTable or CFGrid. The only workaround for me (other than to use ASP)
is to convert all date fields to text fields. This is possible now because I
prepare a special data file for web access. If I were allowing the clients
to hit the live database, which is in future plans, I may not be able to use
CF.
I'm don't believe I can use <TABLE> because there is no functions available
to format date and dollar amounts. Other than that, this app was done and
ready to go live Monday. What a kick in rear. Thanks again. Have a nice day.
See you Tuesday eve.
Regards,
Paige
----- Original Message -----
From: Michael Smith <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 07, 2000 12:04 AM
Subject: Re: Why does blank dates default to 1899-12-30?
>
> --------------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>
&nbs
p;
> 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.mai
[EMAIL PROTECTED]/</a>
> <br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
k">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_ta
lk</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.
------------------------------------------------------------------------------
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.
