subtract dates for duration

[MARTINRODDY]

I am subtracting two dates to get the duration in a certian state. The duration will be in seconds.

Some people have suggested using the:

DateDiff(IntervalType,StartDateTime,EndDateTime)

This is perfect, brillant piece of functionality. The only problem I have is the this function is rectricted to Crystal 8 and I am developing in Crystal 7.

Is there any patchs available to Crystal 7 for this ??? Or has anyone got code that can do this in ver 7??????

Thanks alot.
Martin

 

[Darrick]

Is the data already in a seconds?

If so, then simply subtract the two fields and convert it to the format you want.

Darrick
darrick3@yahoo.com

 

[kenhamady]

I believe this link will give you the V8 date functions that you can add to your V7:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/UFLDateAdd.exe.asp

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com