Crystal 10: Calculate the elapsed time between to dates & times
Crystal 10: Calculate the elapsed time between to dates & times
(OP)
Using crystal 10. Trying to create a formula to find elapsed time between
PDMTimeToDateTime ({call_req.open_date})
Example: 11/12/08 3:31 pm
and
PDMTimeToDateTime ({call_req.close_date})
Example: 11/12/08 4:35 pm
Thanks for any Help!!
PDMTimeToDateTime ({call_req.open_date})
Example: 11/12/08 3:31 pm
and
PDMTimeToDateTime ({call_req.close_date})
Example: 11/12/08 4:35 pm
Thanks for any Help!!
RE: Crystal 10: Calculate the elapsed time between to dates & times
However, to answer your question use the crystal function datediff
datediff("n", ({call_req.open_date}, ({call_req.close_date})
This will return minutes, using h = hours, s = seconds.
Ian