Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need to select DATE on runtime using Date Interface tool

Bakiyaraja
7 - Meteor

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

3 REPLIES 3
Robin_McIntosh
11 - Bolide

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

 

Robin_McIntosh_0-1661796254353.png

 

Bakiyaraja
7 - Meteor

@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
11 - Bolide

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.  

Labels
Top Solution Authors