Specify return value

[Desstro]

I have a query that is set to return data, ("startdate") by criteria of =date().



How can I also set the criteria for another field, ("enddate") to return data that is greater than the system date?

I tried setting enddate criteria to "=>Date()" which obviously didn't work.

[pbaldy]

Try

>=Date()

[Desstro]

Thanks, wasnt quite what I was looking for but it got me pointed in the right direction. For forum purposes I will explain what I was trying to do as well as the solution I found to make it happen.

I have in a query

"Job#"---"Startdate"---"Enddate"---among other options

What I was trying to do was to query any job that is current between the start and end dates.

The solution was to set the criteria for "startdate" to "=Date() or <=Date()"

AND

set the criteria for "enddate" to "=Date() or >=Date()"

Hope this helps somebody in the future, and thanks again pbaldy...you're a guru!