August 1, 200421 yr Does anyone know of a solution to track working hours? I would like to use a simple solution where the user login on his/hers account and register the working hours. Does anyone have any suggestions how to do this solution or is there a solution ready to use today? by the way, i am using FMP7.
August 1, 200421 yr Hi. This isn't a complete/detailed answer, more of a possible scenario. When a user logs in you could populate a global field with the current date using Get(CurrentDate). At the same time populate another field with the time of the login using Get(CurrentTime). Once user logs out you can grab Get(CurrentDate) again and Get(CurrentTime). Compare logout CurrentDate to the global date you stored previously. That will tell you if they have worked past midnite if the 2nd date is greater than the 1st by a day. Use the date calc to drive another calc that subtracts login from logout to determine how long they have worked. FM7 has a good function to convert time differnces to durations. Kurt
Create an account or sign in to comment