[RESOLVED] Invalid use of Null

[aikidokid]

I am adding some dates to an array of variant Date type and I get the above error and I thought this was correct.
I searched here (post #2) and found the answer to be the same as I am doing:

For i = 0 To 13
    If chkHistory(i).Value = vbChecked Then
        GradeHistoryDates(i) = dtpHistory(i).Value
    Else
        GradeHistoryDates(i) = Null
    End If
Next i

[salvelinus]

Try:
Set GradeHistoryDates(1) = Null

[brucevde]

How did you declare the GradeHistoryDates array? It must be declared as

Dim GradeHistoryDates(13) As Variant

[aikidokid]

Haven't had a chance to get back to this yet ;-)

I have declared it as:

Public GradeHistoryDates(13) As Date

Why can't you do this then

[brucevde]

In VB, Variant is the only data type that can be Null.

[aikidokid]

So is Null the best way to handle empty dates?