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)
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)