Make sure the month is in the 1-12 range and make sure it's a valid year before you submit? You could also just throw in 1 for the day if it is not otherwise noted...
Eric -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 January 2007 08:55 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:268166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
