AnsweredAssumed Answered

Finding >=2014-Q1

Question asked by DLarsen on Apr 15, 2014
Latest reply on Apr 15, 2014 by DLarsen

I have a TEXT field where all of the entries are in this syntax:

 

2014-Q1

 

When I sort the records the results is as expected.

 

Example:

2014-Q1

2014-Q2

2014-Q3

2014-Q4

2015-Q1

and so on.

 

What I want to do is FIND all records greater than or equal to a specific quarter.

 

Example:

>=2014-Q1

 

When I perform a find like that I get records prior to, and after, the specified quarter.

 

Thoughts?

Outcomes