Alteryx Designer Desktop Discussions

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

How a User can select a Date using the calendar in the Interface.

rohit782192
11 - Bolide

I am having an excel file which contains date. I want  to calculate the difference in the date.

 

A End user should select the date from the calendar tool and should pass the value to the select and formula tool and output should calculate the difference.

4 REPLIES 4
DataNath
17 - Castor
17 - Castor

@rohit782192 as your app says 'Select a Today date', I'm guessing you want to change the DateTimeToday() to the user's selection? If so, I've updated the app. I basically set up a dummy date (1900-01-01), which is updated by your users selection by specifying which part of the expression is replaced in the action tool:

 

DataNath_2-1657103491524.pngDataNath_3-1657103502782.pngDataNath_4-1657103533163.pngDataNath_5-1657103550610.png

 

If you want this to change the other date rather than being this way round, you can just change the [Date(YYYY-MM-DD)] field in the same way.

grazitti_sapna
17 - Castor

Hi @rohit782192 , give this a try.

 

grazitti_sapna_0-1657103537758.png

Also, I made changes to the difference formula as your formula would result in a negative value.

 

grazitti_sapna_1-1657103575385.png

 

In case you want the value to be negative then you can change the column names in the formula.

 

I hope this helps!

 

Thanks!

Sapna Gupta
rohit782192
11 - Bolide

Ooh Sorry It should be like select any date and pass the value.

DataNath
17 - Castor
17 - Castor

How does this look @rohit782192? If you're asking users to select a date then there's no need for the Excel input, you can just provide the app with a dummy Text Input date in place that gets updated.

 

DataNath_0-1657104317435.png

 

Labels
Top Solution Authors