Forum Discussion
Solved
DATEDIFF
Hi Team, I have the following data I just wanted to count those records with status = "IN" and the time difference between the dates > 30 minutes for the same mobile number. In this example, ...
Hi Jos13 ,
In this example, the expected output is 2. One for 771234 and 1 from 6671.
I don't quite understand your calculation logic. How do you get the result of 2? Which row is meet your requirements? Can you explain it in more detail for me?
Best Regards,
Icey