@dBrand
You can utilize a Patch function or a ForAll function to achieve what you are looking for.
Since you don't seem to want to actually update the date in the originating table and instead want to duplicate the data in another table, then the ForAll (which is a function that returns a Table...not a For Loop!!) is what will do the trick.
Consider the following formula:
ForAll(col_Test1,
{Date1: Text(DateAdd(DateValue(Date1), -1, Years), ShortDate)}
)
Would return a table of all the dates adjusted by 1 year.
If you want that in another duplicated collection, and not using it directly, then you just put it into a collection.
Ex:
ClearCollect(col_Test2,
ForAll(col_Test1,
{Date1: DateAdd(Date1, -1, Years)}
)
)
If you want to change all the dates in an existing collection, then the following will do that:
Patch(col_Test1, col_Test1, ForAll(col_Test1, {Date1: Text(DateAdd(DateValue(Date1), -1, Years), ShortDate)}))
Note: since you specified text for Date1, all of the date to text and text to date conversions in the above formulas are needed. If you had just specified a date, they would not.
I hope this is helpful for you.