Search results

SELECT DISTINCT purch_hist.PUITM AS ITEM, purch_hist.PUPO AS PO, purch_hist.PUQTY AS QTY_RECEIVED, CDate([purch_hist.PURDT]) AS RECEIPT_DATE, itmcnt.ITBYR AS BUYER, purch_hist.PUCST AS UNIT_COST, vendor.NVNO AS VENDOR NO, NewVend.NVNM AS VENDOR, purch_hist.PUCOMM AS COMMODITY FROM...

I'm positive it's a text field. If the table creators would have made the receipt date field with a date/time property rather than a text property none of this would be happening.

Sorry that was my bad. I added the WHERE clause after I posted and forgot to edit the semicolon out. The semicolon isn't the issue because it would bring up a different error. I'm not at work right now but I'll try to see if your solution works.

Hi this is my first post here. I have this linked table query from a OBDC and I need to be able to filter out specific dates in that query. The dates in the table were in text format and I converted the dates using the CDate function. I wanted to filter the query to a single date and always I...