Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Interval Time Problem: Crystal 8.5

Status
Not open for further replies.

caddy36

Technical User
Aug 18, 2003
14
0
0
US
I'm doing a calculation in a Formula that works fine until I reach the 24 hour mark which makes my forumla invalid.

Can someone tell me what I need to do to update the statement to account for times greater than 24hours?

My Statement:
time(DateDiff("d",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp})-(if datepart("n",{reservation_request.rr_create_stamp}) < datepart("n",{reservation_request.rr_completestamp})+1 then 0 else 1),DateDiff("n",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp}) mod 60,00)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top