Create records from WeekOfYear

[john9210]

I would like to create a script that,given a value of WeekOfYear, creates seven new records, and populates the date fields with dates that correspond to the WeekOfYear. For example, for WeekOfYear 14, 2011, the new records would have the dates 3/27/11, 3/28/11, 3/29/11, 3/30/11, 3/31/11, 4/1/11 and 4/2/11.

[comment]

Hint:

The Sunday on or before Jan. 1 is the starting day of week 1.

The starting day of week x is 7*(x - 1) days later.

[john9210]

Hint:

The Sunday on or before Jan. 1 is the starting day of week 1.

The starting day of week x is 7*(x - 1) days later.

Thanks for the tip. I'm not sure why the formula works, but it works beautifully! And simple too!

John