ACCESS ODBC QUERY TO SAGE 100 - Date column format

Access 2003/Sage 100 ver. 2014

Using a linked table in access

Can't get figure how to format the date value...keep getting errors.

Tried {d '2018-01-01'} =#01/01/2018#  ...no luck

sql select blahfield, blahfield where table.datecolumn=>{d '2018-01-01'}

Lot's of comments around on this, but can't get past it.