Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Time difference calculation in crystal reports 7.0

Posted on 2003-02-28
9
Medium Priority
?
4,991 Views
Last Modified: 2009-04-07
hi . i want to calculate time difference between two times in crystal reports 7.0 .. (i know in 8.o onwards crystal gave formula DateDiff(,,)).. i have downloaded u2ldtdif.dll .. but not usefule since i can not able to convert result datetime value into time ...i have time stored in database..
1.  Start time  10:00:00 AM
2.   end time   11:30:00 AM

result should be 1:30 Hrs.

Can anybody help me ..
0
Comment
Question by:amlooks
  • 5
  • 3
9 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 8041832
You can download the updated date functions from

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

mlmcc
0
 

Author Comment

by:amlooks
ID: 8043991
hi .. i have searched all ufls .. but in vain .. how can i use dateadd to get time difference between two dates .. there is datediff function ..(ufl) .. but it returns in
"xx days xx hours xx minutes xx seconds" which i can not use ...  since my application is of time sheet .. user will enter only time spent during the day .. Now for reporting i have to do it in crystal .. If u can give any example ,, it will be great help ..
0
 
LVL 1

Expert Comment

by:NatashaV
ID: 8044769
Is your start/end time a datetime type or a string?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 101

Expert Comment

by:mlmcc
ID: 8045814
Are you looking for functions to calculate number of hours worked in a day given the start and end times?

What format will the data be in?

mlmcc
0
 

Author Comment

by:amlooks
ID: 8055441
hi .. i am using standard datetime field in access.. i am storing work done from x to y time .. i am storing like
Start work .. 10:00:00 AM (datetiem field)
End Work..     2:30:00 PM  (datetiem field)
so work done is 4:30 Hrs.. like this i have to show total hours in a day & also for each work .. I have downloaded one sample from cyrstal but it is in string format .. not datetime format ..

amit
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8056935
I'll see if I can develop one.

mlmcc
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 200 total points
ID: 8057587
0
 

Author Comment

by:amlooks
ID: 8063057
Thanks a lot ..
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8064569
Glad I could help

mlmcc
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question