Hey everyone, I'm trying to put together a custom PO History report but I'm having an issue with the PO Date field.
I'm getting most of the data from the POLINE table. Current fields are
PO-Number
LINE-NBR
POVAGRMTLN.BASE-COST
POVAGRMNTLN.UOM
PURCHORDER.PO-DATE
When I use criteria selection on PO-DATE >= 06/01/2016, nothing comes up. When I use an "=" sign, I get records.
When I limit the amount of records to 10 and use the >= sign, I get some records with a PO-Date of 1/15/2015 which makes no sense.
Any ideas?