You are doing it correctly but the number you used is wrong. Always remember that Activity ID default character length is 10. If you dont use the whole 10 characters then you need to count also the space. If your Activity ID having 5 character long and wanted to retain the last four the criteria should be RIGHT(ACT,9) "4 + 5 space"
Member for
15 years 4 monthsRE: Change of Activity ID using gloal change
Thanks Mr.Rodel. i have used it.
Member for
19 yearsRE: Change of Activity ID using gloal change
Gokulakrishnan,
You are doing it correctly but the number you used is wrong. Always remember that Activity ID default character length is 10. If you dont use the whole 10 characters then you need to count also the space. If your Activity ID having 5 character long and wanted to retain the last four the criteria should be RIGHT(ACT,9) "4 + 5 space"