Devon Southall has a great look at Date and Time fields in the the Dynamics GP Builders series (SmartList Builder, Excel Builder, etc.)
Date & Time fields in Dynamics GP Builders
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.