I want to display the difference between above two dates in minutes.Can some one please let me know how to calculate this measure.
I have used the “daysbetween” fuction and it only returns the difference of days but I require the difference in minutes.
Hi,
diffnumberseconds = to_date(,‘HH:MI:SS’) - to_date(,‘HH:MI:SS’) you will get number of seconds to convert in minutes divide by 60.
you will get what you want. I hope this helps