sql query to retrieve a future date

[mparab]

Hi,

I'm creating a timetracking app. I need to display the payperiod ending date on my page. I have a table with all the ending dates for payperiods. My question is how do I retrieve a date for the future, I know how to get a past date, ie:BETWEEN (NOW( ) - INTERVAL 14 DAY) AND NOW( ). But I don't know how to get a future one. I tried to use the + sign but got an error. Any help would be great. Until then,

thanks alot,

mparab

[TheIceman5]

plus sign should work fine

BETWEEN NOW( ) AND (NOW( )+ INTERVAL 14 DAY).

[mparab]

I forgot to say thanks, I tried that before but it didn't work, and when you told me I decided to try again and it worked. Go figure. Anyway thanks, sorry for the late reply

Manik