Helo folks!

I am buiding a database that among other things like invoicing, etc.. It calculates the comission due to each individual salesperson in the company.

Of course the database has a "creation date" field, into with I can perform, in search mode, a search for weeks, months or exact dates, etc...

The problem is:

I don't want the user to type dificult comands in the "creation date" fields like ">02.01.2004<12.01.2004" when working out the comission due to each salesperson.

I would like to read your sugestions on how you have done it in a more user friendly way. I mean a script attached to a button that would open a window with a list of months, or even a text box for entering a more user friendly entry.

The comissions are payed monthly, but I have to further provide other search means.

Thanks for your comments,

Hi,

I recently finished a rather evoluted Scripted Find interface, where you'd input either a date, a range or some other strings in a user-friendly interface.

May be I could extract it and post it here.

Basically,

A) 3 main options in 4 drop-down boxes :

- "from" and "to"

- "newer"

- "older"

each dropdown with values of type :"days", "weeks", "months" and "years".

C) an option to narrow the search by either the current date (exact) or the beginning of a month/year

D) an input box for a fixed Date inputs.

E) a scripts that checks for valid date entries, then converts the "text string" into a valid text date range into an insert calculaed result.

Here's attached a screenshot of a more complex Scripting Find solution, from which it comes.

Take a look to the sample section as I posted a small example.

HTH

Bernando, meu nome

Meu email [email protected]

Please keep your post in English.

Thanks

Lee