Choosing Calender Period from From and To values

[#1]

Hi,

I am trying to create a calender object with 'From' and 'To' Dates, instead of choosing a range.

How do I write script to integrate the time period to reflect in charts for example?

Can anyone help?

DK

[stephencredmond]

Hi,

You would need to add the selected dates into a Set in your calculation. Something like:

Sum({< Sales_Date = {">$(=DateFrom)<$(=DateTo)"}>} Sales)

Stephen

[#3]

Hi Stephen,

Thanks for your reply.

I have got only one date field available to use. How do I use to create DateFrom and DateTo to be able to filter from just one field value?

Appreciate your help.

DK

[stephencredmond]

Hi,

You could use 2 variables and use 2 Calendar Controls (Slider/Calendar).

Stephen

[#5]

Hi,

Finding it difficult to implement the idea as QV Script. I have got one date field called 'startdate' and need to apply TO & FROM date range using this field to filter table data or chart data dynamically. Can you please explain me with a sample script? DK