.. a value for the month?<BR><BR>Something like:<BR>1=Jan<BR>2=Feb<BR>3=Mar<BR>..<BR>12=Dec<B R><BR>?<BR><BR>If so, just add 1 to it.<BR><BR>Otherwise, if it's a full date value, the other poster was correct - use DateAdd().
I have used + 30 in an Oracle sql query before... I posted that in your earlier thread. Try and stick with your threads instead of opening new ones!! This is part of a query I have used in the past that worked adding 30 days to the current date:<BR>....<BR> MYSQL = MYSQL & "WHERE SOL.TERMINATION_DATE BETWEEN SYSDATE - 30 AND SYSDATE + 30 "<BR> MYSQL = MYSQL & "ORDER BY SOL.TERMINATION_DATE"<BR>....<BR><BR>How isn't it working?