Searching (between) dates entered into a text field
Hi I have a database that users are entering dates DD/MM/YYYY into one of the text fields. Is there any way to search this text fieldusing find mode to retrieve records between two entered dates: Eg. All records between 1/1/1880 and 31/12/1890 Keeping in mind it's a text field. Also, changing the field to a date field is unfortunately not an option.