I am in the process of moving a database from Access to Filemaker. One
field is giving me some problems working out the best way to handle
it. The date fields have the format of yyyymmdd with "99999999"
representing "forever" or "does not expire".
I can import the dates into the new data base with a calculation to
change to the fm date format BUT how can I handle the "forever" dates?
OR would it be best to define all of these as numbers with some kind
of calculation for input validation?
