gud day!
Im developing a report for dtr. Now,the database has only one field for all the time-in and time-out. I am having difficulty on how will I get all the datetime for a month, in 4 separate columns. There is a limit for timein, timeout,etc.. Like, in timein, time should only be from 6:00am - 10:00am..
The format should be:
date timein(am) departure(am) timein(pm) timeout(pm)
Please help me.. I badly need the code... Thanks in advance..
Im developing a report for dtr. Now,the database has only one field for all the time-in and time-out. I am having difficulty on how will I get all the datetime for a month, in 4 separate columns. There is a limit for timein, timeout,etc.. Like, in timein, time should only be from 6:00am - 10:00am..
The format should be:
date timein(am) departure(am) timein(pm) timeout(pm)
Please help me.. I badly need the code... Thanks in advance..