Hi,
I have a data set which has 3 columns, Original Date, New Date, and Change Type. I want to have a script go through and each row then compare the two dates where if the Original Date is blank, then fill it with the new date. Once finished, I need to have a status output into the Change Type column which based on if the dates are equal to, greater than, or less than each other, will result in a new status.
Bookmarks