timboellis

How can I setup a field so that you can write to the field which is going to be called diary , so that you can enter notes then it will add that note with a time stamp within the logs but you are not able to remove the notes already there?

I understand this, but in saying this I would need to change this every month, is there not a dynamic way to do this. ie with wildcards <1/1/2006 (before 1st Jan 200*) >31/12/2000 (after 31st Dec 200*) 1/1/2006..31/1/200* (between, and including 1st Jan to 31st Jan 2006)

How do I search for dates in this format I have a database with various dates and I need to search fields that contain a date, however I need to let it search for dates that are 1 year ago. For example you sign up to my company as a member and the membership lasts 1 year, so i need to find out which ones are about to expire how do i do this. Thanks Tim