Purchase Orders over 30 Days Old

[MBNelsonCR]

I am using 8.5 and an ODBC Connection. The two fields that I am using to filter my report are:

Sales_Header.OrderDate
Sales_Header.ExpectedDate

I would like to find any POs that have gone longer than 30 days beyond their ExpectedDate.

I have tried the following:
(to display the required records)

IF CurrentDate >= DateAdd( 'm', 1 , {Purchase_Header.Expected Receipt Date}) THEN TRUE

and:
(To suppress the records)

IF CurrentDate <= ({Purchase_Header.Expected Receipt Date} + 30) THEN TRUE

I have had some success, but then when I try and browse the report to specific pages, I receive the following error message:

&quot;Date must be between year 1 and 9999&quot;.

In fact, it seems no matter what combination I use, I get this message.

Any suggestions?

Thanks!

Mike
I have checked

 

[synapsevampire]

If you place the following in the record selection criteria, it should limit the rows returned to those older than 30 days:

{Purchase_Header.Expected Receipt Date} < currentdate-30

or to show only the 30 day or less rows:

{Purchase_Header.Expected Receipt Date} >= currentdate-30

If you're still getting a year error, I'd guess that it's either a bad date on the PC, or the format of the date in the date field. Try right clicking the date field and select browse data.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com