till date

[#1]

i hav a date column, i want user to select a date and the records to be shown till tht date,

object can be a chart

and

also a table box.

[Lee_Matthews]

Setup a variable called vFilterDate. Add a calendar object that uses the variable. Then try something like this as your expression (assuming ShipDate is the field you want to display):

=if(ShipDate-$(vFilterDate)>0, ShipDate-$(vFilterDate), null())

The key thing is you want nulls to result in the expression for dates that dont meet the condition. Then the chart ignores them by default, leaving only th edata you want to display.

[#3]

in the example, i hav selected dec12, according to table box i shld get 14 as o/p

bt frm ur expression its showing 18

[#4]

Still i ddin't understand Prashant..

In my table I have data for

12th Feb  is 6

12th Oct  is 8

12th Nov is 4

12th Dec is 2

So If you are selecting 10th December , It will show 18 (6+8+4).

If you select 12th December, it will show 20 (6+8+4+2).

Note: I am using DD/MM/YYYY format...

Regards,

Karthik

[#5]

O yes the problem ws with the format, so mistaken....

working the same approach in the main application,

can u send me the application frm the calender qvd is generated.

thanks a lot...

[#6]

Prashant,

Find attachment.

Please mark Correct answer, that will help other developers like us..

Karthik