Remove a digit from ACTIVITY ID
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Dear Pinan and zeeshan thank you for the excellent bit of information.
regards
deb
Yes he is absolutely right just to add one more thing that Primavera 3.1 activity id consist of 10 char and left will take chr from the left 1st char and right will take char from the right 10th char interesting thing is that even if your activity not consist of 10 chars it will start couting from 10 digit
so if id is 123456 and you use right(act,5) it give you 6 only
thanks
THEN act eq left(act,4) & right(act,5)