Interface Prompt Using a Formula

[Mike_Olson]

I have an app I am deploying to the Gallery where the user is prompted for start and end dates.  The data table is updated monthly mid-month through the end of the month 2 months prior.  I would like to be able to show the user the latest date available in the data based on a formula.  Is this possible?

Currently this is the question prompt:

Data Pull Start Date - Data are updated monthly on the first Thursday after the 10th through the end of the month two months prior (i.e. through October on December 15th)

What I want the prompt to say:

Data Pull Start Date - Data are available through 10/31/2022

Where 10/31/2022 is calculated from a formula (which is complicated but I have one that works).

Is there a way to have this prompt be generated dynamically?  Ideally this would also update the default value but there is no default date option for date prompts, which is a separate complaint.

[MatthewO]

@Mike_Olson my recommendation is to leverage a Drop Down interface tool. The interface tool could be configured to read data from an external source that contains the list of available dates, for example. Depending on your use case, you could also explore creating a chained analytic app to dynamically populate selections based on user input. 

[KSowers]

This is a test sample of what I'm thinking. By clicking run on the first app, it'll complete the calculation for you and show in the app 2 dropdown. The user can then put in their start date and you can have that reflect in whichever tool it needs to be changed in within the App2. Mark this as a solution if this works for you,  If it confusing then let me know!

[Mike_Olson]

Thanks, this is clever.  The problem is that I need it to stay a date selection tool since there are cases where the user would not need data through the most recent date available (historical reports).  But I can see how I could use this to show the user the max date and then have them put their chosen date in on a date tool.

[KSowers]

This could be a decent way of doing it. Still giving the freedom to choose but giving them a drop down that tells them what the max date should be