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?
Chris -----Original Message----- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 30, 2007 10:04 AM To: CF-Talk Subject: RE: Date Validation 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:268052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
