Variable Script Field based on Dashboard Selection

[#1]

I want to have two fields that will be populated with the minimum and maximum dates selected.

The minimum and maximum dates will be taken from a concatenated table so they need be pulled using an IF statement.

something like If ( Table = 'STOCK', Max (Date))

I would want this to be a separate field in my table so that the same date would run down my data and can be used to created a separate "SUMIF"

[Anonymous]

If you want max and min dates of the user selection, then it wouldn't be calculated in the script. I would recommend using set analysis for that. Also, once you run the script your "concatenated tables" become 1 table inside the dashboard....that's the whole purpose of concatenating tables. Are you saying that the user is going to be selecting the name of a table? Will need a sample file or example of your data structure to understand the question what you're trying to accomplish.

[#3]

I've changed my approach as you said it wouldn't be calculated in the script. Many thanks for your help