Jump to content
Sign in to follow this  
SoundPad

Searching by Date?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

:)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.