I have a data table that contains 2 columns. Customer number and Customer DOB.
I want to create 1 additional date column called DOB Plus 1 month which would be the addition of one month to the DOB original column.
So for each row, whatever the DOB value is, add one more and then populate the 3rd column called DOB Plus 1 month.
I can do this via a ForLoop and it works perfectly fine but my question is whether there is a more efficient .select method that I could use to achieve the same thing without a loop ( which can be slow sometimes).