Remove a digit from ACTIVITY ID
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 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)