topic i need the maximum date in array in VBScript in QlikView

i need the maximum date in array in VBScript

udaya_kumar — Tue, 17 Apr 2012 13:56:39 GMT

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 — Tue, 17 Apr 2012 14:04:52 GMT

Something like this?

dtmMaxDate = 0

for i = 0 to MyArray.Count -1

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

msgbox dtmMaxDate

CELAMBARASAN — Tue, 17 Apr 2012 14:20:35 GMT

Hi,

How you store the dates in array?

Celambarasan

CELAMBARASAN — Tue, 17 Apr 2012 14:28:00 GMT

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))

Celambarasan

udaya_kumar — Tue, 17 Apr 2012 14:54:23 GMT

Thanks for reply Celambarasan