I want to update data for a client table where the dates are out of sync with our official records. We are processing batches where we want to add days to the date in the client data table.
I have been working with the 'Fields to Update' Source/Destination expression, but have been unable to successfully use the AddDays expression to the Client Data table date.
The expression works when pulling in Today's date (AddDays(GetDate(),35) but I am unsure of how to target the Client Data date field in place of the 'GetDate()' function.
In this case, my table is called @cusJourneyMembers.
Ultimately I am trying to target the Client Data Table date field: AddDays(insertClientDataTableDateField,35)