Thank you Haikuo really appreciate it. yes my question is not very generic , Ill explain my question in more generic terms If I have a dataset which has the following columns dates id number age .... etc 1) I just want to copy over the previous available data for all columns next month if there is no next month date so say my first date is 31may2000, i want to copy over all existing columns to 30jun2000 if there is a 30 jun 2000 then keep that data otherwise copy over the previous month's data The date specified as you have should be the end date to copy over the data Thank you so much!!
... View more