Suggestion:Date Range (Period)

[#1]

Hello every one,

I need suggeation od date range selection.

In my dashboard I have to give date range selection (period). They are

WeekToDate, MonthToDate, YearToDate, Rollin12Months, Rolling3Months, last year, LastMonth, Custom Date Range and many more. By selecting any one of above I should get related data and Display date range for the selected period. I know there are many functions I can use; I am not sure how to use custom Date Range, rolling 3 months, rolling12months for which we don't have any functions available.

For custom range selection, We have to use Calander (Slidbar), so by selecting any period calander should change display of date based on selected period. So it will display the range.

If any one has suggestions and examples to do it in easy and better way, please feel free to post.

Thank you in advance.

[#2]

Dear John,

I would like to make a file with master calendar and range table with my sample data. But the table links look like as below. I think there should be an error in my code. How can I fix this?

Best Regards,