Date range script

[fbugeja]

I have just finished a student tracking database for use at the school I teach at. In showing it to the School Executive, the Principal was wondering if there was an easier way in entering dates and date ranges. Instead of entering //, <specific date>, >date, date1..date2 in the Date field on the Search layout, he was wondering if you could use terms such as Today, Yesterday, This Week (>date to today), This Month (first day of current month..//), From Beginning Of Year (1.1.2005..//), Term 1 (date1..date2), etc, from a drop down menu which would then transfer the required dates to the Date field on the Search layout.

The idea would be that when the Search button is clicked, it would go to a layout where the teacher would select the appropriate word - Today, Yesterday, This Week, etc - then click a continue button which would take the user to the Search screen where the date is automatically inserted in the Date field based on what word the teacher has selected.

Any ideas or suggestions?

Frank Bugeja

[aaa]

Is not better to create buttons for this constant searchings?

[fbugeja]

Dear aaa

Please give me an example of what you mean

Frank

[aaa]

For today button this script:

Enter Find mode

Set field Date Today

Perform Find

For Yesterdy this:

Enter Find mode

Set field Date Today-1

Perform Find

For this week anything like this:

Enter Find mode

Insert Calc result Date Today-Day(Today)&".."

Perform Find

and ......

[fbugeja]

Thanks aaa!

Frank