Please help to filter data using calender object.

[durgabhavani]

Hi All,

Please help me to filter data using the calender object. Find the qvw attachment with sample data and my fields.

1. Data needs to be filtered based on the calender input.
2. Once I click on clear all button then data selection needs to be cleared and should show the data between the current month range.
( ex: if we filtered May month (1st to 31st) data through calender and then click on clear button and data needs to be filtered from (June 3rd to June 29th ).

Please advice.

This is highly appreciated.

Thanks,
Durga

[m_woolf]

Selecting Arbitrary Date Ranges - YouTube

[durgabhavani]

not able to get second output. please advice.

Thanks,

Durga

[Anil_Babu_Samineni]

For Second one have a look. I would ask you to close this thread and mark as helpful. That may helps in future threads

[durgabhavani]

Thanks for reply Anil.

When click on clear all button. data needs to be filtered from june 3rd to june 29th. I am not able to find it in your application.

[Anil_Babu_Samineni]

I assume, You have to use search string over the same like below. And how about Year, Which year dates you want to filter after hitting the button or Clear all?

='>=' & Date(Today(),'dd-MMM-yyyy') & '<=' & Date(Today()+14,'dd-MMM-yyyy')

[Muthu]

Hi,

I have corrected the QVW as requested. Please check whether it helps.

Regards,

Muthu

[durgabhavani]

Current year current month Anil

[durgabhavani]

thanks muthu its working in your application. I will incorporate the same into my application and let you know the result.

[Muthu]

I have made changes in variable event triggers and clear all button in application..