Is this a field of type text or of type TimeStamp?
The History field is an "Edit Box" in which I am adding the date stamps manually
An "edit box" is layout format designation. What I am asking is what data type was assigned when you defined the field. Open Manage | Database | Fields and check to see if this field is of type text or type timestamp.
I suspect that this is a field of type text--which will complicate the issue.
Are you making one entry per field or are you making multiple entries in the same field?
If you are making multiple entries into one field, this will be one of the first things we'll need to change here.
Thank you four your quick response... I have it as "Text". What this section of the database is doing is keeping track of how many times certain asset is being accessed and modified, keeping track of the date and time in the history section. The History section has multiple entries in the same field, since I could not find a better way to populate this information. What would you recommend to do in order to make this happen? you mention changing the filed to a single entry instead of multiple entries in one, but how can I keep a history then?
You use a table of related records where each record logs a different change in your change history. You can then display all the related records in a portal to show the change history for that item.
This would allow you to count all change recrords that fall in a given date range very easily and through a number of different methods--for all change records or just for a given item's change history.
As a text field with multiple entries, you'd have to extract all the date entries into seperate records and convert them from date to text to do this anyway. This will be complicated by the fact that your text field allows nonstandard or even incorrect text to be entered as a date.