christopherb I think i may have lost it.... simple query to find a record by a particular date, such as... FIND Object WHERE Object.DateAttribute=10/10/2008 The query does not seem to work. I know that data is there and the value of the Attribute is as in the string.
tford the value of the Attribute is as in the string. If you mean that DateAttribute is a Plain Text attribute, shouldn't it be: FIND Object WHERE Object.DateAttribute='10/10/2008' with the quotes? Tom
christopherb Nope it's a date attribute format MM/dd/yy Which leads me to another question... if the format is that as above why is data within the table showing as 10/23/2008? Cheers,
tford You can collect the date from the user in a RegularUser form, then use that date in the query. For example, your query would look like: FIND Invoice WHERE Invoice.InvoiceDate=LoggedInSystemUser.DateSelected Tom