From Steve Endow Unable to run SQL query on GP data with dates – Conversion of a varchar to a datetime error
Dynamics GP Land: Unable to run SQL query on GP data with dates – Conversion of a varchar to a datetime error
SQL & DataInstall, Upgrade & Admin
Archived post from 2015. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.