This topic is locked

Listing New or Edited Records by Date Range

8/15/2014 2:07:36 PM
PHPRunner General questions
V
vlarosa author

Hello All!
I am trying to figure out the best way to accomplish this AND have it be easy for the user. I have a DB with two tables (Recog, and Surety). In both of these tables I have fields for "date created" (surety_create, and recog_create) and "date updated" (surety_update and recog_update).
Recog DB is Master and linked to Surety via the recog number (recog_no).
Now, I need to be able to have the user choose and date range wherein they select a desired range, click a custom search button, and any files within that range that have been either edited OR added as new show up in a list (very much like a generic search of, say the recog number).
Any thoughts or ideas?
Thanks!
Vince