Hi. I am an Oracle user but have been asked to write a simple SQL statement in MS Query for Excel... but am getting stuck on syntax. Here is basically what I am trying to do..

select name
from department
where date_created between ? and ?

The problem I am having is that date_created is time stamped in my database, so, for example, if the user enters the parameters March 1 and March 2 in Excel, the select will not pick up any records created after midnight on March 2 (I have tried TEXT function and also +1 to my date but receive errors).

In Oracle I would write something like this to solve, but there is no TRUNC in MS Query:
select name
from department
where TRUNC(date_created) between ? and ?

How do I write my MS query SQL to handle this?

Thanks,
Rob