You might want to try using the DATEDIFF Function:
DateDiff('hour', [Prev_update_time], [update_time])
you can change the bold to the level of time you want the difference for. There are other options for calculating the difference between 2 datetime fields.
It might help, if you could tell us what format your fields are in and what result you expect after finding the difference.
Thank you so much for your reply.
The two columns in datetime data type are as below.
when i subtract these two datetime fileds it gives me a floating point number like 0.010 (not an exact value)
the requirement is to show the in terms of days, hrs , min and seconds... like 0 days, 0 hrs , 10 min and 25 secs.
Please let me know . Thanks
I am able to achieve the result in the required format by using datediff func and then concatenating the calulated fileds,
I m finding the result in this format
I mite need to convert in 12 hr and 60 min format. Also a hypen - appears though i have nt hardcoded it.