Skip to Content
0
Jun 02 at 06:19 AM

Need to dynamically set default value for a date prompt by querying a table

33 Views

I wish to create a report with 3 prompts and then set default values for the bottom 2 prompts based on the value selected in the first prompt.

Let us say these are the 3 prompts that I need to add to my report,

1. Version number

2. Version start date

3. Version end date

And say I also have a table named 'version' with columns - 'version_number', 'version_start_date' and 'version_end_date'. and that table has 3 rows with these values ((5.1, 01/01/2020, 06/30/2020), (5.2, 07/01/2020, 12/31/2020), (5.3, 01/01/2021, 06/30/2021))

I wish to populate the Version start date and Version end date prompts based on the value selected in Version number prompt. So, say if I select or enter 5.2 value in Version number prompt then I want Version start date and Version end date prompts to have default value of 07/01/2020 and 12/31/2020 respectively.

Any help with this is appreciated.