I have a found set of accounts, for each account I am creating a set of records starting at the current date with each additional child record's date field incrementing by 8 days. The two loops are working fine.

Date Records

1. 7/1/2016
2. 7/9/2016
3. 7/17/2016
4. 7/25/2016
5. 8/2/2016
6. etc.

I would like to stagger the start dates into 4 groups

1. 1st Account's record sequence starts today.
2. 2nd Account'srecord sequence starts 7 days later.
3. 3rd Account'srecord sequence starts 14 days later.
4. 4th Account'srecord sequence starts 28 days later.
5. 5th Account'srecord sequence starts today.
6. 6th Account'srecord sequence starts 7 days later.
7. 7th Account'srecord sequence starts 14 days later.
8. 8th Account'srecord sequence starts 28 days later.
9. 9th Account'srecord sequence starts today.
10. 10th Account'srecord sequence starts 7 days later.
11. 11th Account'srecord sequence starts 14 days later.
12. 12th Account'srecord sequence starts 28 days later.
13. ... and so on.

New Account 1 Date Records (the same)

1. 7/1/2016
2. 7/9/2016
3. 7/17/2016
4. 7/25/2016
5. 8/2/2016
6. etc.

New Account 2 Date Records (starts 7 days later)

1. 7/8/2016
2. 7/16/2016
3. 7/24/2016
4. 8/1/2016
5. 8/9/2016
6. etc.

What would be the structure to set the date field to the correct staggered date for the account records as I loop through the account found set.

Well, you could use:

Mod ( Get ( RecordNumber ) - 1 ; 4 ) * 7

(while in the Accounts table) to determine the initial offset. That is assuming that after 14 comes 21, not 28 as you have written.

However, I would urge you to reconsider your overall strategy. What is the purpose of creating all these records? Surely there must be a simpler way to accomplish whatever this is supposed to accomplish?

I am creating a yearly contact schedule for each account, lets say visit each account every 3 weeks.

So all visits don't happen on the same weeks, I'm staggering the start week for each visit sequence, so account 1 starts this week, account 2 next week, account 3 in 3 weeks, account 4 in 4 weeks, then start over, account 5 this week. I'm open to other ways of doing it.

Well, if you're going to actually use those visit records by entering some data into them during the actual visit, then it makes sense. Personally, I prefer not to create a record until I have some real data to enter into it, but it can work either way.

Thanks, the mod calculation worked great.