Hi Fellow KNIMERs,
I have a table to track project dates for tasks on the project. I am trying to clean up the data on the date columns to make sure actualized date columns (columns ending in *_A__c) only have dates in the past and any future dates need to be moved to the forecasted column (columns ending in *_F__c). In some caes the forecast column does not exist, so would need to create one and then move the future dates into the forecast column.
The above table should be changed to:
I have created a loop on the list columns that need to looked at and IF SWITCH to determine if there are 2 columns for the TASK (A and F columns). I am stuck trying to move the dates.
Any help would be appreciated.