March 23, 200520 yr Newbies 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).
March 23, 200520 yr 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.
Create an account or sign in to comment