help !! needed in Arbitrary date range selection

[fashid]

Hi,

I have been struggling to get my date range selections working but i dont understand where i am failing .

If any body could help me with my sample app or a hint where im doing it wrong .

I would grreatly appreciate it.

Thanks and Regards,

Nadeem

[renjithpl]

Please give more information so that people can answer.

[fashid]

Hi,

In My application i need a from date and to date for the users to select .

I have tried to create the same using this thread Selecting Arbitrary Date Ranges

But i am unable to get it to work .

I have attached the application that i am working on

Regards,

Nadeem

[Anonymous]

as far as I noticed is that your Standard date Format is M/D/YYYY

Your listbox work as Long as there is a  valid date Format that way (10 of february will be displayed corect while

23rd of feburary will not be correct)

so try to Change the date Format in Tab main to SET Dateformat='DD/MM/YYYY'

[fashid]

Hi Rudolf,

Thanks for replying

Tried that but still does not work

If i select a group of dates in the CalendarDate field then the slider objects react and show correct range of dates

but not vice versa.

Regards,

Nadeem

[Anonymous]

what do you mean with vice versa?

you select a date in the calendar objects on the left and you want the listbox or the table to adjust?

that is not possible as you are using variables in the calendar objects

you might try variable Triggers for that, but i am not sure if that works

If you use ONE calendar and you define the field CalendarDate instead of variable and set Multiple Values

you can select a date range in the calendar object and changes the date in the listbox according to the Dates.

But that is not convenient for larger date ranges

Please try what fits best for you

[Anonymous · Accepted solution]

Hi,

PFA. Let me know if this is what you are looking for. I made changes in the document triggers for the two variables.

Regards,

Greeshma

[fashid]

hi,

I have already tried triggers please check my qvw application

Regards,

Nadeem

[fashid]

Hi Greeshma,

Thanks a lot for helping me out.

I was struglling with this for quite some time now .

This is exactly what i was looking for .

I think it Was it not recognising the date in the variables inside the triggers .

Could you please explain what the issue was ????

Regards,

Nadeem

[Anonymous]

Hi Nadeem,

The issue was with the triggers on vstartdate and venddate.

Your trigger action was   '>= $(vstartdate) <= $(venddate)'

I changed this to '>=' & Date(vstartdate,'DD/MM/YYYY') & '<=' & Date(venddate,'DD/MM/YYYY')

Only >= and <= had to be given inside quotes. Also date format had to be changed to match the format as per CalendarDate.

Regards,

Greeshma