Inserting an interval as value of a Number Field
I'd like to know if it is possible to insert an interval as a value of a Field and how can I do it. I'd also like it to pop out in a search where the number searched for is one of that interval.
Example: to record an event that took place between the year 2000 and 2005. If I search for all the events that took place in 2004 I'd like my record to pop out.
I hope the question is well posed and clear, thank you in advance.