How to run a query on a truncated date

[Faz]

Hallo,

I need to do a simple query to search for database records as follows:

Show me all records where the truncated current date (defined as Now()
in access) is between the two fields called effective_start_date and
effective_end_date.

In the query I have created an Expression defined as Now(). In the
criteria I have put the following criteria:
Between [effective_start_date] And [effective_end_date].

How can I change the Now() expression to show the truncated version of
Now() as I need to pick up records that have an end date of today as
well.

Thanks.

[Br]

Faz wrote:

Hallo,

I need to do a simple query to search for database records as follows:

Show me all records where the truncated current date (defined as Now()
in access) is between the two fields called effective_start_date and
effective_end_date.

In the query I have created an Expression defined as Now(). In the
criteria I have put the following criteria:
Between [effective_start_date] And [effective_end_date].

How can I change the Now() expression to show the truncated version of
Now() as I need to pick up records that have an end date of today as
well.

Thanks.

Date() ???

Br@dley