Date

[#1]

How do I get last 10 days dates in the list box or a straight table chart.

Please help.

Thanks

[#2]

hi,

Take a List box

put expression as: ValueLoop(Today()-9,Today())

go to Number tab and change the format to Date

you will get the last 10 days from current date.

[#3]

Hi,

You can use this script.

LET varMinDate = Num(Today()-9);

LET varMaxDate = num(today());

Calendar:

Load

    $(varMinDate)+IterNo()-1 AS Num,

    Date($(varMinDate)+IterNo()-1) AS Date

AUTOGENERATE 1 WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);

Regards,

Kush

[v_iyyappan]

Hi,

     I attached a sample QV application.

Hope its helpful for u..

Thanks,

Iyyappan