DateDiff problem (1 Viewer)

[Christine5017]

I have a datediff problem that I cannot figure out, could someone please help me.

I have a query with Date Start and Date End. (along with their first name, last name and ss)
What I need from this report is a list of what employee is still open. (not passed the Date End)

I hope that I explained this for it is very confusing to write it down.
Any help would be great.

 

[RV]

>What I need from this report is a list of what employee is still open. (not passed the Date End) <

What do you mean by "not passed the Date End", not passed comparing to what (I guess, which date)?

RV

 

[Pat Hartman]

The criteria for the EndDate field should be:
> Date()

This will show you all records where the EndDate field is greater than today's date.

 

[Christine5017]

Thank you so very much Pat. It works great!