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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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