How to Choose data within a particular date range

[SS157]

Hi,

I have to make a custom date range picker. So that user can pick date of his/her choice and the graphs are modified according to it. In the data there will be separate column for "From date" and "To Date". The choice of date selection for year, month and quarter will be up to user. 

It will be very helpful if someone can suggest me appropriate technique for the same. 

Thanks in Advance. 

[tush]

Hi,

     You can try Date Picker, which is available in June 2019 version.

Thanks

Tushar

[rathore01]

hi there,
Date:
Load PrimaryKey, From_Date as Date, From_Date resident mastertable;
Concatenate
Load PrimaryKey, To_Date as Date, To_Date resident mastertable;

Drop field From_Date, To_Date from mastertable;

Now your newly created Date table will have data like
PrimaryKey, Date, From_Date, To_Date

Use Date Range Picker extension, give Date field and see the results
And if you want two sepearte date range picker for from and to date then pass the values accordingly

[SS157]

If we use date range picker, we are not able to get the dynamic range as by user. Suppose if the user wants to show the sales in the third quarter of 2017 to fourth quarter of 2018. Like That Date range picker i need. 

If its possible i would like you to add some of the screen shots to guide me to.

[SS157]

If its possible i would like you to add some of the screen shots to guide me to. I tried it did'nt give the appropriate  results.