Hi. I have a text field in a table that is a date in the format of m/d/yyyy. I need to be able to search for dates in between a [beginning] and [ending] date. With this being a text field, naturally it does not work correctly in all cases.
What is the best way to handle? Do I convert it to a date field? If so, what is the best way to do that in the query? If I should keep it in the text format, is there a way I can guarantee that I will get all records? Sorry...new to all of this and trying to learn how to best proceed. (The field name is [Last Start].
Any guidance please?
Kindest regards and thanks,
sren