Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Advanced Find Number F...

Advanced Find Number Field

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am trying to locate records that require a number, but I need a range of numbers like 1-30. It says that it is an invalid number. How do I search for a range?

*This post is locked for comments

All responses (5)

Answers (0)

Suggested answer

TheMarkChristie 10,328 on at

Like (0)

Report

RE: Advanced Find Number Field

Hi Mr Etuck

A simple Greater Than 0 and Less than 30 would work
Community Member Microsoft Employee on at

Like (0)

Report

RE: Advanced Find Number Field

Got it. Thanks again!
Community Member Microsoft Employee on at

Like (0)

Report

RE: Advanced Find Number Field

I knew it was something easy. Thanks a ton!
Suggested answer

ScottDurow 50,177 on at

Like (1)

Report

RE: Advanced Find Number Field

Hi,

You will need to add two conditions in to the advanced find filter

'Is Greater or equal to' 1

AND

'Is Less than or equal to' 30

Hope this helps
Community Member Microsoft Employee on at

Like (0)

Report

RE: Advanced Find Number Field

Thank you for the reply Mr. Preite. I did enter 1-30 in the field and received the invalid number error message. Is there a particular symbol I should be using? Thanks again for the reply.