CRV10. I have a numeric field (EMPLOYEE.NBR) that could contain up to 9 digits. I need to select only the employee numbers that end with either 3 or 8. Could someone possibly help me with the formula? Thanks!
Hi,
Use the ToText function to change it to text, then the Right
function to test the last character..See the help file for details on using these.
Something like this for a selection criteria formula:
Code:
Right(ToText({employee.nbr},'#'),1) in ['3','8']
Something like that should do what you want..
To Paraphrase:"The Help you get is proportional to the Help you give.."
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.