Writing at DynamicsCare, Dwight Specht tackles a really obscure issue with Analysis Cubes: Conversion failed when converting Date and/or Time
Analysis Cubes: Conversion failed when converting Date and/or Time | DynamicsCare
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.