I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One of the properties of my object is a start date. Everything inserts and updates to the MySQL database without a problem. This issue that I am having is when I try to perform any CF date functions on the stored date.
If I try to do a datecompare or datediff function on the start date, I get a "Date value passed to date function DateCompare is unspecified or invalid" error message. However, if I try either isValid("date",Deal.getStartDate()) or isDate(Deal.getStartDate()), both return true. Any thoughts? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm