Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
my file having "CarrDate" field contains of 30 days of dates .
Now my requirement is i need to use the "CarrDate" field in two InputBoxes with dropdown as StartDate and EndDate.
I.e; StartDate inputbox should have all the 30 days dates but in EndDate inputbox should have >=StartDate.
Ex:
StartDate
01-05-2011
02-05-2011
03-05-2011
04-05-2011
05-05-2011
06-05-2011
07-05-2011
.
.
30-05-2011 HINT: If i am selecting 05-05-2011 in StartDate then should start with which is >= current selection,
the EndDate should start from 05-05-2011.(pls see below)
==========================================
EndDate
05-05-2011
06-05-2011
07-05-2011
.
.
30-05-2011
Pls share your ideas on this issue.
Thnks
Hi,
you could use the concat - function to generate the list of possible values for the inputbox.
I.e.you have two variables var1 and var2 and a field called date1:
The list of restricted values for var1 is calculated like this: =concat(Datum, ';', Datum )
and for var2 only dates that are >= var1 are shown: =concat({$<Datum={">=$(Variable1)"}>} Datum, ';', Datum)
I attached a qvw to this post that demonstrate my approach.
I guess that should solve your problem.
Cheers,
Gerald
Gerald - I love this solution. Thank you very much. I had learnt something new
Cheers - DV