Need to select DATE on runtime using Date Interface tool

[Bakiyaraja]

Could you please help I Need to select DATE on runtime using Date Interface tool 

EX: if we have 2 year data like (4 quarter for each year) in total 8 quarter data 

I should able to select any period of date like 01-01-2021 to 31-03-2021 on run time . 

Please find the attached input data

[Robin_McIntosh]

An interface then where the user is able to select the dates.  This is an analytic app but displays the browse results.

[Bakiyaraja]

@Robin_McIntosh  that above solution work but there will be issue in the date format.

it will be applying filter in the below date format

DD-MM-YYYY

but my data is in MM-DD-YYYY

is there any way we can change/choose the format of date according to my data.

please find the attached workflow source data.

could you please help me on the same

[Amol_Telore]

Hey @Bakiyaraja 

Date format will not be an issue as datatype for DATE field in excel file is date. Thus even if you are seeing MM/DD/YYYY in excel file, While reading data in Alteryx it will be treated as YYYY-MM-DD cause Alteryx recognized the date data type. 

I have done one change in the @Robin_McIntosh workflow at filter section. PFA for reference.

If this solution answers your queries then please mark @Robin_McIntosh response as a solution.