I have a field that is text 255 that contains number and letters. Ex.
I place them in a variable and I use replace to remove the text and only retain numbers(All good).
But the problem is when I use this variable to and store the value in a currency,integer, or number field I get Datatype mismatch error. What should I do?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
CapNcook
Hi Everyone,
![image.png.605b6af20016ed7605bf8caa7371b3b6.png](//content.invisioncic.com/r269793/monthly_2023_12/image.png.605b6af20016ed7605bf8caa7371b3b6.png)
![image.png.61dab8abc359ac01fc3638d9f8ac6b81.png](//content.invisioncic.com/r269793/monthly_2023_12/image.png.61dab8abc359ac01fc3638d9f8ac6b81.png)
I have a field that is text 255 that contains number and letters. Ex.
I place them in a variable and I use replace to remove the text and only retain numbers(All good).
But the problem is when I use this variable to and store the value in a currency,integer, or number field I get Datatype mismatch error. What should I do?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.