Hi Everyone,
My requirement is to change the table fields value to logical months by using another field. Below is the example:
Actual Table contains a field name as below and Data month field always contains one specific Month value- '1/1/2016' in DD/MM/YYYY format.
Now I need to change the below columns accordingly. ie.., Month 1 should change to the value present in Data Month and Month 2 should be Data date-1 and so on till Month 24.
| Table Fileds | I need |
|---|
| Customer | Costomer |
| Address | Address |
| Data Month | Data Month |
| Month 1 | Jan'16 |
| Month 2 | Dec'15 |
| Month 3 | Nov'15 |
| Month ... | Oct' |
| Month 24 | Jan'14 |
Could someone please guide me how to do this at the script level.
Thanks,
Jaswanth
