I have the below openquery which works fine but now I want to select only transactions >= `'2017-07-01'` using `gl_trans.gl_trans_date` but cannot get the correct syntax. The backend database is Informix
I have tried many suggestions via google without success :(

```
SELECT *
FROM OpenQuery(PRONTO_L01, 'SELECT 
gl_trans.gl_accountcode,
gl_trans.gl_amount,
gl_trans.gl_trans_date ,
gl_trans.gl_details
FROM gl_trans
WHERE gl_trans.gl_amount <> 0')

```