How a User can select a Date using the calendar in the Interface.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ooh Sorry It should be like select any date and pass the value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
