-----Original Message-----
From: Paige Chandler <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, July 07, 2000 9:10 AM
Subject: Re: Why does blank dates default to 1899-12-30?
>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
No, that's your workaround. By dropping CFTABLE you'll gain a lot more control
over the display of your data. CF has _many_ built in display formatting
functions. There's DateFormat(), DollarFormat(), NumberFormat() and others.
Jim
------------------------------------------------------------------------------
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.
