For those database tables which contain fields called START_DATE and END_DATE the following special tasks may be of use:
| Current | This will set the dummy field 'curr_or_hist' to 'C' in the search criteria for the calling script, then return control to that script. This has the effect of creating a $where string containing start_date <= $now AND end_date >= $now. |
| Historic | This will set the dummy field 'curr_or_hist' to 'H' in the search criteria for the calling script, then return control to that script. This has the effect of creating a $where string containing end_date < $now. |
| Future | This will set the dummy field 'curr_or_hist' to 'F' in the search criteria for the calling script, then return control to that script. This has the effect of creating a $where string containing start_date > now. |
These can be added to the navigation bar of relevant tasks so that fresh data can be retrieved using different date selection criteria without having to go through a SEARCH screen.
Note that there is no 'ALL' option as this is already catered for by the RESET button in the action bar which will clear all current selection criteria.
In SEARCH screens the 'current', 'historic' and 'future' options may be made available in a dropdown list.
