Searching by Date?

[SoundPad]

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

[mz123]

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

:)

[SoundPad]

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, 2007 by Guest

[Jonathan Smith]

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!