Skip to Content
Former Member
Nov 04, 2015 at 07:27 PM

ToDate formula gives an error


Hi All,

I have a Date field coming from a SQL server table that is in a string format and looks like this 12-25-2015

I need to be able to convert this to a Date format such as MM/dd/yy in Business Objects however when i use the following formula

ToDate(My Date; "MM/dd/yy") I get the following error on the report #ERROR.

Any help is greatly appreciated.