> Have you got your own date validation function?
 > Or have you got isdate() all over the place?

Standard cfform validation:

<cfinput name="II_D_DC5"
    value="#dateformat(getapp.II_D_DC5,'mm/dd/yyyy')#"
    class="II_D_DC1"
    type="text"
    message="Please enter a valid date"
    validateat="onSubmit"
    validate="date" />

> Yea, you could do something before your queries run that check the form
> scope for your date values, and check if isDate().  If not, check if you
> can pull out the month and year separate (maybe just use listGetAt(1,
> form.date1, '/') ) and then re-write that form value to be the 1st?

Just got off the phone with them - if they don't associate a specific 
day with the date, then for legal reasons there *can't* be specific day 
with it - it can't even default to the 1st. They may even want to enter 
"sometime in 1979"!

That pretty much changes everything. Looking like I'll have to change 
all the SQL Date fields to accept text and just let them enter whatever 
the heck they want, since that's what they're asking ("1/23/2006" or 
"2/1998" or "sometime in 1987"!).

Whatever!! - this is outside the original spec that *specified* 
specific date formats, so I get to bill them more now. They're lawyers, 
so they have unlimited pockets anyway, no?

Clients! They'll walk all over you with "feature creep" if you let them, 
huh?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268055
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to