To pick the value in the variable

[Anonymous]

Hi Masters,

I have a table in which there are two columns Pipeline Scenario Date, Pipeline Scenario Categories.

In front end I have Pipeline scenario Categories displayed in the list box

I want when the user select in any of the pipeline scenario categories the pipeline scenario date associated with that category will get store in a variable

and that variable il use in my set

Appreciate your help

Thanks in advance

[#2]

Hi,

Create a variable and use GetCurrentSelections(Fieldname) in definition. Fieldname must be based on Pipeline Scenario Categories.

Regards,

Janzen

[jonathandienst · Accepted solution]

Hi

Use this in the script:

Set vScenDate = =Max([Pipeline Scenario Date]);

Now if you select a pipeline scenario, then the vScenDate will contain the corresponding date.

You could also use Min instead of Max. If you want the variable to contain nothing when no scenario category is selected, then change Max to Only.

Regards

Jonathan

The double = sign is not a typo

[Anonymous]

Thanks Jonathan

What a answer thanks for the quick response tooo:)