You can use the picture function to map it to the proper date format and then use the CTime() function to convert it to a time data type.

CTime(Picture({field}, "xx:xx:xx"))

Then use the DateAdd() function to do calculations on the field.

I have all the Crystal Reports functions documented with sample code in Chapter 6 of my Crystal Reports Encyclopedia book


Edited by BrianBischof - 28 Nov 2007 at 1:56pm

That should be CTime() instead of CDate(). I originally wrote CDate() in my post but then changed it to CTime() once I read your question a second time. That should get you up and running.


Edited by BrianBischof - 28 Nov 2007 at 2:29pm