no takers? Well regardless, I updated the other post with some info about the underlying problem. It would seem that there was an automagic system casting dates to text in the past, but no longer. So, substring is not the problem as was first mentioned but rather just the lack of casting a date to text is.
to_date(DATETIME, 'YYYY-MM-DD') or similar _should_ do the trick. -------------------- m2f -------------------- -- http://www.openerp.com/forum/viewtopic.php?p=26050#26050 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
