[RESOLVED] Invalid use of Null

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:

Code:

---

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

---

Try:
Set GradeHistoryDates(1) = Null

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

Dim GradeHistoryDates(13) As Variant

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 :confused:

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

So is Null the best way to handle empty dates?