Change of Activity ID using gloal change
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Thanks Mr.Rodel. i have used it.
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"