Time Clock entry deletion

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.

Reply to
jeff
Loading thread data ...

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.

Reply to
Matt Hurst

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

Craig

Reply to
Craig Wood

Reply to
yu yu

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.