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

Question

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.

Difference.yxwz

DateSelected.xlsx

grazitti_sapna · Accepted Answer

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!

DataNath · Accepted Answer

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.