Find Date Range

Good day..

How to write a find between the date range... I keep on get the error.

FIND InvoiceHeader WHERE InvoiceHeader.InvoiceDate>='01-09-2011'

FIND InvoiceHeader WHERE InvoiceHeader.InvoiceDate>=AS_STRING('01-09-2011')

FIND InvoiceHeader WHERE InvoiceHeader.InvoiceDate>=AS_DATE('01-09-2011')

FIND InvoiceHeader WHERE InvoiceHeader.InvoiceDate>=AS_DATE'01-09-2011','DD-MM-YYYY')

All give the me the error... how to change the above...

please help.. thanks..

hi,

what type of attribute is InvoiceDate of the BO InvoiceHeader?

I keep on get the error.

If you want help with an error, it's always a good idea to share what the error is.

Otherwise it's like a friend of mine says "it's like trying to send a haircut in the mail"

tford wrote
like a friend of mine says "it's like trying to send a haircut in the mail"

so you don't want to invest in my latest venture... eBarber.com?

Try

FIND InvoiceHeader WHERE InvoiceHeader.InvoiceDate>=DATE(1,9,2011)

or just remove the ' as in

FIND InvoiceHeader WHERE InvoiceHeader.InvoiceDate>=01-09-2011

Your 4th option has a bracket missing after AS_DATE - that may be just a mistake in your post but would throw an error in the configuration tool

Finally, are you sure InvoiceHeader.InvoiceDate has it's format set as DD-MM-YYYY,

there are many possible causes but as Tom said, unless you post the error message it is about as much use as a chocolate coffee pot