Clever Geek Handbook

How to get DateTime difference in Crystal Report

How can I get the DateTime difference between two DateTime fields in Crystal Report?

I have tried using DateDiff with the inconvenience,

Any help / hint would be appreciated.

Thank,

-1


source to share


1 answer


You are not giving enough information to help us solve your problem.

Getting results using dateDiff may mean that there is a Null value in your data.



At the "File / Report Parameters" level, you have the option to "convert Null values ​​to default" (this might be an incorrect translation, since I am not working with the English version of CR ..). Select this option to have Null dates in your database treated as dates in your function. Try to get dateDiff result. If it still doesn't work, use a draft report to display all intermediate results in your function, or try writing it in basic syntax instead of Crystal Syntx.

+1


source






More articles:


All Articles