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

[rohit782192]

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.

[DataNath]

@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:

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 · Accepted solution]

Hi @rohit782192 , give this a try.

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

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

I hope this helps!

Thanks!

[rohit782192]

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

[DataNath · Accepted solution]

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.