How can I perform a find that checks against another tables date
I have two dates databases. One has random dates and the other is a set date. I to perform a find that does the following:
If date1 (the random dates) is less then date2(the date that always just has one record) then do whatever I want it to like sort, export, etc. When I try to do it in a find it gives me "the value of this field must be a valid date in the range of years 1 to 4000 and should look like "12/25/2003"." It works to do ">//" but seams like I can't pull a value from the date database. Is there anything I can do about that?
Thanks for the help!