Yes, default the date to: MONTH/01/YEAR -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 30, 2007 9:55 AM To: CF-Talk Subject: Date Validation
I have an application running on a SQL Server Database. There's a large number of date fields scattered about through out the forms. I've put Coldfusion validation on them all, and am using cfqueryparam (date) in all my insert/update queries and the SQL Fields are all "date" as well. Now, the client says "We just wanna enter a month and year when we feel like it whenever a specific day doesn't apply". Obviously, "2/1998" doesn't validate. Suggestions?? - hopefully without having to redesign half the database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:268051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
