Slider/Calendar Object Properties issue.

[renuka_sasikumar]

Hi,

I have two Date Field,

I am using two calendar object.

One for Start Date & second for End Date.

I am not able to find where I am going wrong for the same I have attached the QVW.

Can anyone help me on this urgently.

[sunny_talwar]

Try it out now:

Expression used: ='>=' & TimeStamp(vDateZero) & '<=' & TimeStamp(vEndDate)

But I suggest truncating your DEAL_DATE to just a date by using Date(DEAL_DATE) function in the script and then you can use this expression for filtering:

='>=' & Date(vDateZero) & '<=' & Date(vEndDate)

[renuka_sasikumar]

Hi,

Sorry I didn't get this.

I want when I select the StartDate in Calendar Object then my Table box should change according to it.

So not able to understand where I should write this expression.

[maxgro]

see the attachment

I modified

menù --> settings --> document properties --> number the format of DEAL_DATE

in text object Generate the search string    = '>=$(=Date(vDateZero))<=$(=Date(vEndDate))'

[sunny_talwar]

Have you tried opening up the application that I have attached above? You had a button called Generate, I just fixed the expression in it to make it work. Now when you select a start and end date and click generate, the range selected in those two calendar objects will be selected.

[renuka_sasikumar]

Hi,

If I want to do the same thing without the Generate Text Box.

For eg: If I select Start Date & End Date then the data should be selected according to that in the Table Box.

Regards,

Renuka S

[maxgro]

add the same action and expression on the 2 variables

[sunny_talwar · Accepted solution]

Check out the attached:

and just so you know, your Start date calendar is linked to a variable called vDateZero and you might want to consider switching it to vStartDate. and if you do that then the expression will change accordingly:

From

='>=' & TimeStamp(vDateZero) & '<=' & TimeStamp(vEndDate)

To

='>=' & TimeStamp(vStartDate) & '<=' & TimeStamp(vEndDate)

[renuka_sasikumar]

Thank you Sunny T.

Regards,

Renuka S

[renuka_sasikumar]

Hi,

I tried this with my actual data, I am facing issue like.

Here I have Two Calendar object i.e. StartDate & EndDate and one Bar chart in that Date is as Dimension.

Now here when i select the date between stat date & enddate no changes occur on Bar chart.

Can you help me on this.