Redirect with query

Oh maybe obvious, but nDate is my variable which holds the date of today. I would like to put this nDate in the url and use BETWEEN with an end date of one week.
Can you pleae help me out.

Hi,
I recommend you to use Between search option on the Advanced search for this purpose.

To construct correct link check following thread:

http://www.asprunner.com/forums/index.php?showtopic=5705

Hi Jane,
Terribly sorry to bother you again.

Your tip got me one step further. However I cannot get it to work. There are a lot of places in the URL where the dates are used. Which one do I use to properly insert my variable? I have no clue. The following url:
[codebox]Response.redirect "tblreserveringen_list.asp?a=advsearch&type=and&asearchfield%5B%5D=ID&asearchopt_ID=Contains&value_ID=&value1_ID=&asearchfield%5B%5D=Reserveringsnummer&asearchopt_Reserveringsnummer=Contains&value_Reserveringsnummer=&value1_Reserveringsnummer=&asearchfield%5B%5D=Object&asearchopt_Object=Equals&value_Object=&value1_Object=&asearchfield%5B%5D=Specificatie&asearchopt_Specificatie=Equals&value_Specificatie=&value1_Specificatie=&asearchfield%5B%5D=Vestiging&asearchopt_Vestiging=Equals&value_Vestiging=&value1_Vestiging=&asearchfield%5B%5D=Werkelijke+aanvrager&asearchopt_Werkelijke_aanvrager=Contains&value_Werkelijke_aanvrager=&value1_Werkelijke_aanvrager=&asearchfield%5B%5D=Gereserveerd+door&asearchopt_Gereserveerd_door=Contains&value_Gereserveerd_door=&value1_Gereserveerd_door=&asearchfield%5B%5D=Datum+reservering&asearchopt_Datum_reservering=Equals&dayvalue_Datum_reservering=&monthvalue_Datum_reservering=&yearvalue_Datum_reservering=&tsvalue_Datum_reservering=0-0-0&value_Datum_reservering=&type_Datum_reservering=date13&dayvalue1_Datum_reservering=&monthvalue1_Datum_reservering=&yearvalue1_Datum_reservering=&tsvalue1_Datum_reservering=0-0-0&value1_Datum_reservering=&type1_Datum_reservering=date13&asearchfield%5B%5D=Gereserveerd+vanaf&asearchopt_Gereserveerd_vanaf=Between&dayvalue_Gereserveerd_vanaf=1&monthvalue_Gereserveerd_vanaf=12&yearvalue_Gereserveerd_vanaf=2008&tsvalue_Gereserveerd_vanaf=1-12-2008&value_Gereserveerd_vanaf=2008-12-1&type_Gereserveerd_vanaf=date13&dayvalue1_Gereserveerd_vanaf=31&monthvalue1_Gereserveerd_vanaf=12&yearvalue1_Gereserveerd_vanaf=2008&tsvalue1_Gereserveerd_vanaf=31-12-2008&value1_Gereserveerd_vanaf=2008-12-31&type1_Gereserveerd_vanaf=date13&asearchfield%5B%5D=Gereserveerd+tot&asearchopt_Gereserveerd_tot=Equals&dayvalue_Gereserveerd_tot=&monthvalue_Gereserveerd_tot=&yearvalue_Gereserveerd_tot=&tsvalue_Gereserveerd_tot=0-0-0&value_Gereserveerd_tot=&type_Gereserveerd_tot=date13&dayvalue1_Gereserveerd_tot=&monthvalue1_Gereserveerd_tot=&yearvalue1_Gereserveerd_tot=&tsv"[/codebox]
Needs to be constructed from two variables:

dateFrom and dateTO
So it uses the 'between' operator to create a week overview of my reservations.

Can you plz help me. I don't see any solution here.
Hans

Hi,
just select correct search parameters on the Advanced search page, enter test dates and run search.

Then replace test date values with your own.

It has been a while since I have visited the forum.

I'm very sorry to be such a pain, but can someone please help me here?
I have the following code in an ASP page:
[codebox] sDate = Now()

sNewDate = DateAdd("d", 7, sDate)
'Here is a list of the different intervals you can use with the DateAdd function:

'

's - Second

'n - Minute

'h - Hour

'd - Day

'y - Day of year

'w - Weekday

'ww - Week of year

'm - Month

'q - Quarter

'yyyy - Year
tyear= year(date)

tmonth=month(date)

if tmonth <10 Then tmonth = "0" & tmonth

tday=day(date)

if tday<10 Then tday = "0" & tday

tdate = tyear & "-" & tmonth & "-" & tday
Response.redirect "tblreserveringen_list.asp?a=advsearch&type=and&asearchfield%5B%5D=ID&asearchopt_ID=Contains&value_ID=&value1_ID=&asearchfield%5B%5D=Reserveringsnummer&asearchopt_Reserveringsnummer=Contains&value_Reserveringsnummer=&value1_Reserveringsnummer=&asearchfield%5B%5D=Object&asearchopt_Object=Equals&value_Object=&value1_Object=&asearchfield%5B%5D=Specificatie&asearchopt_Specificatie=Equals&value_Specificatie=&value1_Specificatie=&asearchfield%5B%5D=Vestiging&asearchopt_Vestiging=Equals&value_Vestiging=&value1_Vestiging=&asearchfield%5B%5D=Werkelijke+aanvrager&asearchopt_Werkelijke_aanvrager=Contains&value_Werkelijke_aanvrager=&value1_Werkelijke_aanvrager=&asearchfield%5B%5D=Gereserveerd+door&asearchopt_Gereserveerd_door=Contains&value_Gereserveerd_door=&value1_Gereserveerd_door=&asearchfield%5B%5D=Datum+reservering&asearchopt_Datum_reservering=Equals&dayvalue_Datum_reservering=&monthvalue_Datum_reservering=&yearvalue_Datum_reservering=&tsvalue_Datum_reservering=0-0-0&value_Datum_reservering=&type_Datum_reservering=date13&dayvalue1_Datum_reservering=&monthvalue1_Datum_reservering=&yearvalue1_Datum_reservering=&tsvalue1_Datum_reservering=0-0-0&value1_Datum_reservering=&type1_Datum_reservering=date13&asearchfield%5B%5D=Gereserveerd+vanaf&asearchopt_Gereserveerd_vanaf=Between&dayvalue_Gereserveerd_vanaf=1&monthvalue_Gereserveerd_vanaf=12&yearvalue_Gereserveerd_vanaf=2008&tsvalue_Gereserveerd_vanaf=" & tdate & "&value_Gereserveerd_vanaf=" & tdate & "&type_Gereserveerd_vanaf=date13&dayvalue1_Gereserveerd_vanaf=31&monthvalue1_Gereserveerd_vanaf=12&yearvalue1_Gereserveerd_vanaf=2008&tsvalue1_Gereserveerd_vanaf=" & sNewDate & "&value1_Gereserveerd_vanaf=" & sNewDate & "&type1_Gereserveerd_vanaf=date13&asearchfield%5B%5D=Gereserveerd+tot&asearchopt_Gereserveerd_tot=Equals&dayvalue_Gereserveerd_tot=&monthvalue_Gereserveerd_tot=&yearvalue_Gereserveerd_tot=&tsvalue_Gereserveerd_tot=0-0-0&value_Gereserveerd_tot=&type_Gereserveerd_tot=date13&dayvalue1_Gereserveerd_tot=&monthvalue1_Gereserveerd_tot=&yearvalue1_Gereserveerd_tot=&tsv"

[/codebox]
This page should redirect the visitor to an asprunner page (tblreserveringen_list.asp) that displays reservations starting today until one week in advance, a so called week overview.
However, sometimes it works, most of the time it doesn't and sometimes it displays all(!) records.

Can someone please advise me?

I'm looking for a way to calculate now() + 7days and then construct my url so that it will display all records from tblReserveringen WHERE `Gereserveerd Door` (which means reserved by) = Between Now And Now+7
Please help me...

Someone must have done something similar before?

Come on guys. Please.

Hi,
in general you need to run advanced search using Between search option, copy URL and then replace two dates with your ones: current date and current date + 7 days.

Hello all,

It has been a while since I was working n this project. I am resuming it at the moment.
Jane,

I did exactly as you say. Now I found out that when I set the form method to get instead of post and I grab the url, it is clipped. It seems that I cannot type anymore characters in the addressbar as well. So that must be my problem: i do not have the entire string to construct my search query on the advanced search page. Do you have a workarounf dor this?
Tia
Hans

Hans,
I'm not sure that I understand you correctly.

Please open a ticket at http://support.xlinesoft.com and send a couple of screenshots explained this issue.