Hello,
Can someone help me create a formula for be...
# generaln
nikhil angawane
02/20/2023, 8:02 AMHello,
Can someone help me create a formula for below requirement?
Pull the account records between 1000 and 2000case {account.number}>'1000' between {account.number}<'2000'nikhil angawane
02/20/2023, 9:55 AMNumber field on the the account is Free-Form Text type field so I cannot use the Formula(numeric) function.
Is there another way to pull the records the BETWEEN 1000 and 2000?
n
NElliott
02/20/2023, 10:35 AMConvert string to number in your formula?
n
nikhil angawane
02/20/2023, 10:36 AMhow to do that?
n
NElliott
02/20/2023, 10:37 AMNo expert with SQL but i'd imagine TO_NUMBER({account.number})
if the syntax is correct
n
nikhil angawane
02/20/2023, 10:38 AMohh. Let me try his
m
Michael McNamara
02/20/2023, 5:23 PMI was just going to say try TO_NUMBER. It’s worked for me on other things.
r
RJMNS
02/21/2023, 5:19 PMCouldn't you do case when {account.number} like '1%' or {account.number} like '2%'? then you wouldn't have to worry about conversions.