AnsweredAssumed Answered

How can I perform a find that checks against another tables date

Question asked by RandyRisser on Jul 10, 2014
Latest reply on Jul 10, 2014 by philmodjunk

Title

How can I perform a find that checks against another tables date

Post

     Hello,

     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!

Outcomes