Simple Query

paddo2002 · Post by **paddo2002** » Sun Dec 30, 2007 11:46 pm

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 · Post by **christopherb** » Mon Dec 31, 2007 1:00 am

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

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

Good luck,
Christopher

paddo2002 · Post by **paddo2002** » Mon Dec 31, 2007 1:09 am

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 · Post by **tford** » Mon Dec 31, 2007 5:16 am

Patrick,

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

Tom

paddo2002 · Post by **paddo2002** » Mon Dec 31, 2007 7:16 am

OOPS

I will give that a try.
Thanks for the help