Compile error: type mismatch

Actually this is from text book.
My code is:

Code:

---

Private Sub mnuCheck_Click()
Dim TempDate As Date
CheckFile = Dir(ThisDir, vbNormal)

Do While CheckFile <> ""

    If Right(CheckFile, 3) = "cqu" Then
    Open CurDir + "\Car Quotes\" + CheckFile For Input As #1
    Line Input #1, TempDate

    If Date - TempDate > 30 Then
    txtDate = TempDate
    End If
    End If
CheckFile = Dir
Loop
End Sub

---

when I tested running it, error code appear and the 'TempDate' is highlighted yellow.
could someone please tell where my mistake is..?

p/s:Just tell me if I need to add more information if the code above is not enough

If you read the help files, you will find that Line Input# wants a string or a variant.
So change TempDate accordingly.

Yes you are getting Line Input & Input confused.
Visit the forum's FAQ section regarding file input/output

I changed a bit and it works

Code:

---

Private Sub mnuCheck_Click()
Dim TempDate As Date
Dim TempDa as String
CheckFile = Dir(ThisDir, vbNormal)

Do While CheckFile <> ""

    If Right(CheckFile, 3) = "cqu" Then
    Open CurDir + "\Car Quotes\" + CheckFile For Input As #1
    Line Input #1, TempDate
  txtDate = TempDate
    If Date - TempDate > 30 Then

    End If
    End If
CheckFile = Dir
Loop
End Sub

---

thanks a lot

Quote:

---

Originally Posted by Bluen

I changed a bit and it works

Code:

---

Private Sub mnuCheck_Click()
Dim TempDate As Date
Dim TempDa as String
CheckFile = Dir(ThisDir, vbNormal)

Do While CheckFile <> ""

    If Right(CheckFile, 3) = "cqu" Then
    Open CurDir + "\Car Quotes\" + CheckFile For Input As #1
    Line Input #1, TempDate
  txtDate = TempDate
    If Date - TempDate > 30 Then

    End If
    End If
CheckFile = Dir
Loop
End Sub

---

thanks a lot

---

You declared a new variable and never used it in the code, and you are still using a Date variable for reading instead of using a string ! :confused:

What VBClassicRocks & LaVolpe suggested is that, you could use a String variable to read the date (ie. in Line Input) and convert that string obtained to an appropriate Date and use it in the rest of the code.

For converting string to date, you could use the CDate() function.
:wave: