Time Clock entry deletion

Jul 09, 2010 3 Replies

Is there away to delete old entries for the time clock in bulk? I understand that I can do them 1 at a time but that would take for ever. I also understand that they will delete when I delete an employee.


you could use a sql script in HQ administrator that looks something like:

DELETE from TimeCard where TimeOut < '01/01/2005'

If you want these archived instead of deleted, make sure to backup the database first.

Another useful query to save for when needed, thanks Matt.

Craig

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required