SoundPad Posted April 27, 2007 Share Posted April 27, 2007 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 Link to comment Share on other sites More sharing options...
mz123 Posted April 27, 2007 Share Posted April 27, 2007 Make sure that the field is defined as a Date and not as a number or text. :) Link to comment Share on other sites More sharing options...
SoundPad Posted April 28, 2007 Author Share Posted April 28, 2007 (edited) 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 Link to comment Share on other sites More sharing options...
Jonathan Smith Posted April 30, 2007 Share Posted April 30, 2007 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! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6206 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now