Run-time error '13': Type mismatch using DatePart() function

[bishoposiris]

I'm running the following code:

Please Login or Register  to view this content.

I'm getting the error at:

Please Login or Register  to view this content.

The date format is 1/1/2016. TransDate is reading 1/1/2016 in this line:

Please Login or Register  to view this content.

SortMonth is an integer. DatePart returns an integer. Why doesn't this work?

[scottiex]

try taking the quotes away from transdate

Please Login or Register  to view this content.

[InvisibleMan]

Scottiex has highlighted what looks like the issue, as Transdate is a variable but would be treated as text if it's in quotes.

This might be a better way of loading your arrays:

Please Login or Register  to view this content.

And then use:

Please Login or Register  to view this content.

to loop through the array.

Given that you actually have 20 items in the array, that might be a safer bet ... you actually use item 17 twice, hence you only count to 19. Or is that intentional?

[bishoposiris]

Scottiex, that was the problem! Thank you.

[bishoposiris]

InvisibleMan, thank you for the helpful Array tips. And for pointing out item 17. That was not intentional. Didn't know about LBound and Ubound either. That will be useful. Thank you.

[InvisibleMan]

You're welcome. Thanks for the rep.