I am trying to write an SQL statement to update dates on an Oracle table. When the date is null in the recordset, an error is received. Access VBA is not allowing Decode or To_Date to be utilized.
You could use isNull(<recordName>) in a VB module to catch the null dates and then change them to some default value that Oracle can accept. I have no experience with Oracle, not sure if this will work for your situation.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.