I am rebuilding a report that was originally created out of the Business View data source and creating a new report out of the ODBC data source connection.  There is a formula that works in the Business View but when I create the same formula in ODBC I get the "A string is required here" error. 

 

The formula is: DTSToDate ({Incdnt.AffctdPersnDOB}).  I have the same exact number of tables and correct joins but don't know why I get the error message.  I really appreciate any guidances.

Thank you,

 

Thank you so much for responding to my post!  Oh, it's a DateTime.  The otehr version was converted to a String.  How do you convert a dateTime to a String format?

 

I really appreciate your help!!!

Thanh

 

Thanks again for the reponse!  I replaced the DTSToDate function with  he Date function and it worked!  Thank you!  I'm not exactly sure why my former co-worker converted the field type from DateTime to String.  I'm curious how he was able to convert the field type from the table from DateTime to String.

 

I appreciate you for helping me with this issue!  Have a great day!

 

Thanh