Date And Time (SQL Vs MS ACCESS)

Hi guys, im really unfamiliar with MS access so could use a bit of guidance.

I have an SQL server back end and MS access front end, im trying to run a simple date query to look at records with todays date only.

In sql it would be something like: -

SELECT Contract, convert(char(10), DispatchDate,103) as [Dispatch Date]
FROM BinLocations
where convert(char(10), DispatchDate,103) = (select convert(char(10), getdate(), 103))

I know i can use date() within MSaccess, but not sure i would convert the datetime field within sql to display this in msaccess.

Anyone have the ms equivilant to my sql query?

Thanks in advance

Note: datatype for this field within sql is date/time