Pass through query help

[dmonney]

I have a table on an ODBC connection where all the dates(RQDATE8_275) are in the yyyymmdd format
I am trying to make a pass through query to retrieve the records with dates before today. With this code I get a missing right parenthises error.


SELECT RQQTY_275 AS TRAV_QTY,PARTNO_201, RQDATE8_275
FROM FRH_MRP.PSK02275_OPEN
WHERE RQDATE8_275 <= dbo.fn_format_datetime(current_date 'yyyymmdd')

 

[dmonney]

Figured it out

I figured it out...

SELECT RQQTY_275 AS TRAV_QTY,PARTNO_201, RQDATE8_275
FROM FRH_MRP.PSK02275_OPEN
WHERE
    RQDATE8_275 <= TO_CHAR(SYSDATE, 'YYYYMMDD')

 

[MSAccessRookie]

It looks like you are missing a Comma in the function call

dbo.fn_format_datetime(GETDATE(), 'yyyyMMdd')

 

[MSAccessRookie]

It looks like you found the answer before I could post. Good for you