.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> VB.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Crystal report issue

Posted By: srini     Posted Date: January 24, 2011    Points:2   Category :VB.Net
Hi,

Could you please tell the formula to find out the difference between two times under a single date in crystal report.

Eg:
Date: 01/24/2011
InTime:09:20:00

Date:01/24/2011
OutTime:06:00:00

I need RESULT like:

Total: 08:40:00

Please help me....

Responses
Author: Narayanan             
Posted Date: October 12, 2011     Points: 20   

Hi srini,
please tell me ,Input values are DateTime format or Time format.
For Ex:
DateTime Format: 01/24/2011 09:20:00
Time Format:09:20:00
Try This
DateDiff (intervalType, startDateTime, endDateTime)
DateDiff("s",CDateTime(Date({StartTime}),Time({StartTime})),CDateTime(Date({EndTime}),Time({EndTime})));

Refer this link:
http://www.lazyasscoder.com/Article.aspx?id=78&title=How+to+calculate+the+date+difference+in+months+in+Crystal+Reports

Regards,
Lakshmi Narayanan.S

Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend