In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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