How to store an associated value into a variable of the date column using VBScript?

[#1]

How to store an associated value in a variable of the date column using VBScript?

Example

Emp Name	Start Date	End Date
Hameeda	8/1/2014	8/13/2024
Santhana	8/1/2014	8/13/2025
Kaleel	8/3/2014	8/13/2026
Ganga	8/4/2014	8/13/2026
Siva	8/5/2014	8/13/2028
Sangeetha	8/6/2014	8/13/2029
Avuthu	8/6/2014	8/13/2030

If we select the employee name ,how to capture the corresponding dates (start date and end date) in a variable using macro vb script.

[Michael_Tarallo]

Hi Hameeda - I assume you mean for QlikView correct? - Can you explain more about your case and the product you are using? I will move this thread to the appropriate discussion forum.

Thanks

Mike

[#3]

Yes.. It is Qlikview.. I am able to save employee name into an variable using macro.But my requirement is if I select an Emp Name (say hameeda) my script should store the the associated date values into two variables (like vSD=8/1/2014 and vED=8/13/2024) ..

[Michael_Tarallo]

OK, I moved it - if you don't hear anything from someone, please feel free to contact me, and I will do my best to help.

Mike

[#5]

Thanks a lot...