Simple Query

paddo2002

Hello again all,
I was wondering if anyone knows how to make a simple query that lets you query a date range for example allows you to enter the start and end dates for all Invoice.Date in a that range?

Cheers
PM

christopherb

P,
You can do something like this.....

FIND Invoice WHERE Invoice.Date>=?Start Date AND Invoice.Date<=?End Date

Good luck,
Christopher

paddo2002

Hi Christopher,
Thanks for the help, but is this a rule? in which case you have to define start date and end date?

What I need is the user to be presented with a form where they can define the start and end date and all the invoices will then be displayed.

Thanks for the help though

Cheers
Patrick

tford

Patrick,

Have you tried putting Christoper's Find.... in a process?

Tom

paddo2002

OOPS

I will give that a try.
Thanks for the help