Newbies leisa Posted January 16 Newbies Share Posted January 16 Our database is made up of different locations, towns, sites etc. There are thousands of entries, each day different locations are updated with current information. Is there anyway to do a search for all records that we haven't updated in say 6 months or a range of dates? I'm looking for records that may have not been updated in a while. Link to comment Share on other sites More sharing options...
Ocean West Posted January 17 Share Posted January 17 Every table should have a field that has an auto-enter timestamp field that uses Get ( CurrentHostTimestamp ) this way if your users are adding records from outside your time zone all records will be based on the server's time zone. You can then do a find on that field that < 7/14/2023 Link to comment Share on other sites More sharing options...
Newbies leisa Posted January 17 Author Newbies Share Posted January 17 (edited) Thanks for the help, unfortunately this doesn't give me accurate information for example the record has a "date modified" field. I entered Find ... <01/07/2023 but I'm still coming up with records that were modified after that date. for example in August and December of that year. I'm in Australia so we do date/month/year. When it didn't work I did a test that should give me no results. For example I entered Find Mode in the "date modified" field and I entered 18/01/2024 which is tomorrows date, it should come up with no records, but it finds 1000. Edited January 17 by leisa Link to comment Share on other sites More sharing options...
comment Posted January 17 Share Posted January 17 3 hours ago, leisa said: I entered Find ... <01/07/2023 but I'm still coming up with records that were modified after that date. 3 hours ago, leisa said: I entered Find Mode in the "date modified" field and I entered 18/01/2024 which is tomorrows date, it should come up with no records, but it finds 1000. It might help to know the exact dates that were found in these attempts. Are you sure the field is defined as a Date field? Link to comment Share on other sites More sharing options...
Newbies leisa Posted January 17 Author Newbies Share Posted January 17 (edited) Yes, they are the only date fields on each record. There is a date modified field (image attached) and a date exported field. Records are modified as information comes to hand, and I wanted to find all records that hadn't been modified in the last 6 to 12 months. I've used the range fields .. and the less than < fields but none return any recogisable data that would give me what I need. I'm using Find ... right clicking in the field to bring up operators then using one of the selections ie. < .. etc Edited January 17 by leisa Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now