Hi Evil Kraig F,

The way this works at the client site is that employees daily worked hours are recorded as Pay Type (Regular) carrying lets say 8 hours each day on their timecard (it's timekeeping system), so when my query runs against this time keeping system on Monday it looks at todays timecard and looks for the Regular Pay Type, once it sees that Pay Type it then adds 8 hours of Regular 2 Pay Type in that timecard via an XML API program.

Now today is Tuesday and again there is a Pay Type of Regular of 8 hours in the timecard for Tuesday, the query runs on Tuesday and it looks at the timecard from today (Tuesday) back to Monday, it ignores Monday's data because there is already a combination of Regular and Regular 2 Pay Types there thus it inserts Pay Type of Regular 2 with 8 hours on Tuesday.

This cycle continues from current Monday till Sunday each week, one thing to note is that if there is a day where there is no Regular Pay Type then it moves on to the next day.

I hope this makes sense 🙂 and thank you for helping..

Regards,