Find Problem

[Todd623]

In my music database I have a Date Created text field.

I have, for example, many records from the year 2013, in the format of 2-1-2013.

However, when I do a search for 2013 I get the "No records match this criteria" error.

Any ideas?

Thank you.

[comment]

That just shows that a Text field is not the optimal data type to store dates (no surprise there...). The default search in a Text field looks for words that start with [...] - and "2-1-2013" is a single word.

You could work around the problem by searching for *2013 (which would be slower than the default search), or solve the problem by converting your data to dates and storing it in a Date field. 

 

[Todd623]

Thank you. Adding an asterisk to the text string was the answer I was looking for.