Hi,

I've set up a database that allows you manage contacts and companies through a marketing process. Within this we allocate "notes" by which you can add tasks to do. Now the problem rises when one tries to look at all "notes" due before a certain date. I enter find mode and type <=24/05/2007 into my date field to search for all "notes" with a to do date on or before the 24th may 2007. The results i get are all dates that have the first two digits less than or equal to 24.

Any clue on fixing this???

Cheers

Elliot

Make sure that the field is defined as a Date and not as a number or text.

:)

Ah perfect thanks. Pretty obvious now. Just another quick question, when using the database in a browser (via instant web publishing) I can't seem to get it to copy and paste more than one field content. Any ideas on a fix?

Cheers

Edited April 28, 200718 yr by Guest

SoundPad-

I am working on a similar problem, I just made a post about it. I have a table with over 120,000 records that I need to clean up. If you have any advice, I would definitely appreciate it!