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, ...
Jos13 , Create a column like
time diff = datediff(maxx(filter(table, [mobile] =earlier([mobile]) && [status] ="Out" && [status] <>earlier([status]) && [Date] <earlier([Date])),[Date]),[Date], minute)
This will time diff in minutes , you need to check for > 30