Date Filtering Help

[Losartan]

Hello,

I have a database where I capture when a task was created and when it was completed [dteDate] and [CompleteDate].

I want to capture the time as well so i document the now() into those fields.

On my form, I want to view only the tasks that are due today. When I put the filter of =date() on my form, nothing shows up.

How do I filter for the tasks for the whole day when the field also has time?

Thanks,
Jason

 

[John Big Booty]

The Now() function includes a time component, so you will never get a match with Date()

Try;

>Date()-1 And <Date()+1

 

[missinglinq]

You mention the date a task is created and the date it is completed, but you really don't mention a field that tells you if a task is "due" today. The general expression to compare a today's date to a field that holds date and time would be something like

Date = CDate(DatePart("m",Now) & "/" & DatePart("d",now) & "/" & DatePart("yyyy",Now))

 

[Losartan]

The Now() function includes a time component, so you will never get a match with Date()

Try;

>Date()-1 And <Date()+1

This worked perfectly!!!

Thanks for your help. This place rocks!

Jason