Help on a select statement

Hi,
you can add where clause on theEdit SQL query tab. Turn on SQL mode and add your WHERE clause.

Actual code is dependent on database type.

Thanks again Jane,
I did figure that out...sorry about not updating the post.
Question: I have the where statement > where FromDate>Now()

This is working... but what if I want to show the records of the "FromDate" for only 5 days after the "FromDate"
Again, thank you for helping me.

Try to use this one:

where FromDate>Now() and FromDate<Now()+5

Try to use this one:

Thanks Jane,
I tried this...it shows the same records as the original Where FromDate>Now().
Could I be doing something wrong? Is there anything I else I can try?
Thanks again for your help!

Sorry for my fault.

Here is the correct code:

where FromDate>Now() and FromDate<date_add(curdate(), interval 5 day)

Sorry for my fault.

Thanks again Jane,
I tried this code and it is returning 0 records now. I have checked the FromDate field and I should be getting at least 5 records.
Again, I want to thank you for taking the time to help me.

Hi Jane,
I played around and finally got it working. Here is what I'm using

where FromDate<>Now()

I'm sure I didn't explain what I wanted it to do correctly.
I want to thank you again for helping me. I'm sure I will be back asking questions.