can you perform any date functions on it at all ?
Try running it through CreateDate() or CreateODBCDate() first and see if
that helps
On Sun, Jan 22, 2012 at 8:48 PM, Dean Lawrence <dean...@gmail.com> wrote:
>
> 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:349602
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
