4 Replies Latest reply on Feb 18, 2010 3:36 PM by epdowd_1

    Using approximate dates



      Using approximate dates


      I am creating a database that tracks the owners of vintage cars over time, but I do not always know the exact date of transfer.  For example, I may know that the car was built on 6/15/1963 and that it later re-sold at some time in 1969.    I would like to use a date like 00/00/1969, but Filemaker 10 (Windows XP) will not accept it. 


      Any suggestions on how to create an approximate date that will sort correctly?