Attendance Data In and Out for Shift Rotation.

Hi there.

I m working on attendance system. I have a table whch stores attendance data. 

the structure of the table is Indate, Intime, Outtime, EntryType, 1 for In and 2 for Out.

MIN and MAX queris working fine for a single day shift. but when the day changes

like In = 02/01/2015 5:00 PM and Out= 03/01/2015 6:00 AM then it gives wrong result. also if user left to swipe In/out then this also gives worng result. 

can anybody gives a good idea to tacke both the situtations.

Thanks in adv.


February 10th, 2015 5:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics