Time Variance Assistance

[Oustasu]

I am using Crystal Reports XI. I am trying to create a formula to do a time variance. I was not able to locate one that calculated what I needed.

What I am trying to do is to count the items that are plus or minus 10 seconds from two fields.

Time format is "6/28/2009 8:05:30 AM"
Field #1 is "Create Date"
Field #2 is "Resolved"

David

 

[IanWaterman]

Use DateDiff

@TimeDiff

datediff("s", datetime1, datetime2)

Will return difference in seconds.

This is a Crystal Reports question rather than Enterprise, you will get a better response if you use forum

Business Objects Crystal Reports 1 Formulas

Ian

 

[Oustasu]

Thank you for the quick reply and the suggestion.