I am using the Lenel Onguard with SQL server dBase to make the time attendance system for our employees.

I summarise each day's transaction to make their first entry and last exit for each day and get the datediff. to get the time duration. But the problem is with night shift employees, it is showing the time out which happened in the morning of the same day where actual exit is on the next day. so the datediff. returning with wring value. Any solutions are most welcomed!