Add-ins issue when filtering purchase order date

 1 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
SCMaster-jk2
Veteran Member Send Private Message
Posts: 100
Veteran Member

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?

Kat V
Veteran Member Send Private Message
Posts: 1020
Veteran Member
PO Date is formatted weirdly - I've never been able to get it to behave in AddIns - so 'me-too' ing this question.