i am using VBScript in QlikView, i have one array, which contains the list of dates, but i want to get the maximum date from the array.
so how can i get it using VBScript?
Something like this?
dtmMaxDate = 0
for i = 0 to MyArray.Count -1
if MyArray(i)> dtmMaxDate then dtmMaxDate = MyArray(i)
How you store the dates in array?
Try like this
MaxDate = CDate(MyArray(0))
for i = 1 to MyArray.Count -1
if CDate(MyArray(i)) > MaxDate then
MaxDate = CDate(MyArray(i))
Thanks for reply Celambarasan
Retrieving data ...