i want to check a date in date list

[#1]

Hi friends

I want to check a user given date in date list .whether is it there or not, If there means I need to show sum of values automatically.

I did it but it show me when I select date from date list  which is same as i was entered in input box. But I need to show the value without selecting date from list box..

This is the variable using in an input box. and my expression is

=if((Date=vDate),Sum(Value)) when i select '08-06-2015'  from date list it show me sum of value of the date. But I want to show the sum of value without am selecting value from date list....

And my table is

I am waiting for your response friends.,....

[tresesco]

Try like:

Sum({<Date={'$(vDate)'}>} Value)

Remember the entered date format and date in field format have to be same. I.e, enter date value like vDate = 08 Jun 2015

[MarcoWedel]

check your date formats.

your screenshots show different ones.

regards

Marco

[#4]

Hey Thank for your response. but it not works perfectly. I just paste that exp In a text box it show me 0. Even I select a date from date list also.

[MK_QSL]

SUM({<Date = {"$(=Date(Date#(vDate,'DD-MM-YYYY'),'DD MMM YYYY'))"}>}Value)

[#6]

Yeah It look diff from my input but it accept my date which enter in input box. and show the sum of value when I select the same date from date list. at the same time it doesn't show any value if I didn't select any date from date list or select a wrong date....

[tresesco]

Try to post a sample qvw.

[#8]

Friend show me whether user input date is available  in a list or not by using a text box. It should be done without selecting the same date from date list

[tresesco]

PFA

[#10]

hey I can't open this file because am using personal edition only. Can you please send screenshot of the desired output or please paste the expression as a reply...