how to search timestamp field

[Jek]

Ok - I give up. How do you do a find a range in a timestamp field? I want to find all records in a table that have been created today. So I switch to Find mode and enter a range in the CreateTimeStamp field. Voila - nothing. I've typed in every combination of things that seem to work in other fields but I either get nothing or a bunch of records that were created anytime from today to months ago (not all records mind you, just some).

[sbg2]

Are you entering a full timestamp or just the date? To search for a range of today in a timestamp field you would search for:

3/23/2005 12:00:00 AM...3/23/2005 11:59:59 PM

If you want to search by just the date either create a calc-field that results in a date and search the calc field. Otherwise you could create a script that prompts for two dates and formats that into the timestamp format, Enters find mode, sets timestamp field to the specified range and performs the find.