>>Nope... Yeap! :-)
>>The code use to work on CF5 but now bombs out with CF7 The code worked because you were lucky, and the date was probabily formated some other way CF could guess a valid date from the string. With CF 7 you're just not so lucky ;-) see: http://www.contentbox.com/claude/customtags/convertDate/viewConvertDate.cfm You're problem is that you're suplying a string as a date when you should supply a date. Only functions like createdate or now() return date type values, only createODBCdate functions create dates suitable for queries, and these functions take date values as parameters, not strings. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54