How to ensure number is between 0 and 1000?

Help Studio
1

Hi all,

I am using an If activity to check that the number value is between 0 and 1000.

This is how i retrieve the number from my DT: row.Item(“Age”).IsNumeric

How do I check that what was retrieved is valid?

Thanks

2

Hi @SRoyi

Try this

If IsNumeric(row("Age").ToString) AndAlso
   Double.Parse(row("Age").ToString) >= 0 AndAlso
   Double.Parse(row("Age").ToString) <= 1000 Then
    ' The value is numeric and within the range (0, 1000)
    ' Add your workflow logic here
Else
    ' The value is either not numeric or not within the range
    ' Add your alternative workflow logic here
End If

Regards

3

Thanks, it works just as wanted

1 Like
4

@SRoyi

You’re welcome

Happy Automation

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.