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.
- posted
13 years ago
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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.