I AM TRYING TO FILTER A TABLE BY A DATETIME FIELD BUT I AM HAVING SOME PROBLEMS.

I AM USING A CODE LIKE THIS:

BETWEEN(ACTIVITY.mydatetimefield,linidatetime_AM,lfindatetime_AM)

BUT is including record that are PM too.
I Supposed that this is only considering the DATE for filter and not the time.

Please, i need help.

It's not necessarily just looking at the date.
For example, {07/27/2000 23:00:00} is between {07/27/2000 10:00:00} and {07/28/2000 10:00:00}.
add an HOUR() criteria to the where clause
note: HOUR() always returns in 24 hour format

AND HOUR(ACTIVITY.mydatetimefield)<12