I'm setting up a db with a "Location" table that has fields "Country, State, City, County, From and To"
I'd like From and To to be simply years, e.g. 1886, 1952, whatever, but I want to be able to eventually pull out selected records such as give me the names of the people (in another related table) who worked in this County between this year and that year.
Would it be best to try to set up From and To as dates or as numbers? I've been trying all sorts of variations of input masks / formats with the Date/Time data type to get just the 4-digit year with no success.
Thanks for any thoughts.