Find date attribute

christopherb · Post by **christopherb** » Mon Oct 27, 2008 5:07 pm

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 · Post by **tford** » Mon Oct 27, 2008 6:52 pm

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 · Post by **christopherb** » Mon Oct 27, 2008 7:37 pm

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 · Post by **tford** » Mon Oct 27, 2008 8:46 pm

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