Project a date 30 days out...

<i><b>Originally posted by : meldrape (meldrape@texas.net)</b></i><br /><br />Greetings!<br /><br />I have a web page where I am trying to write the below excerpt of my SQL statement to project a date 30 days out from the current date. Right now it is like this:<br /><br />"WHERE ((Programs.PgmDate) Between #5/15/00# And #6/15/00#) ORDER BY (Programs.PgmDate);")<br /><br />Which works great, but I have to update it all the time (everyday!)<br /><br />Any help would be greatly appreciated! thanks.<br /><br />Mel<br />

<i><b>Originally posted by : </b></i><br />Try this:<br /><br />"WHERE ((Programs.PgmDate) Between #"&Date&"# And #"&DateAdd("d",30,Date)&"#) ORDER BY (Programs.PgmDate);")<br /><br />The solution above was found at:<br /><br />http://msdn.microsoft.com/scripting/default.htm?/scripting/vbScript/doc/vbstoc.htm<br /><br />------------<br />meldrape at 5/27/2000 2:19:30 PM<br /><br /><br />Greetings!<br /><br />I have a web page where I am trying to write the below excerpt of my SQL statement to project a date 30 days out from the current date. Right now it is like this:<br /><br />"WHERE ((Programs.PgmDate) Between #5/15/00# And #6/15/00#) ORDER BY (Programs.PgmDate);")<br /><br />Which works great, but I have to update it all the time (everyday!)<br /><br />Any help would be greatly appreciated! thanks.<br /><br />Mel<br />