i need the maximum date in array in VBScript

[udaya_kumar]

hi,

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?

[m_woolf]

Something like this?

dtmMaxDate = 0

for i = 0 to MyArray.Count -1

     if MyArray(i)> dtmMaxDate then dtmMaxDate = MyArray(i)

next

msgbox dtmMaxDate

[CELAMBARASAN]

Hi,

     How you store the dates in array?

Celambarasan

[CELAMBARASAN · Accepted solution]

Hi,

     Try like this

MaxDate = CDate(MyArray(0))

for i = 1 to MyArray.Count -1

     if CDate(MyArray(i)) > MaxDate then

          MaxDate = CDate(MyArray(i))

next

Celambarasan

[udaya_kumar]

Thanks for reply Celambarasan