Hello VB programmers,

In my program I do have to find out or a field (format Date) is greater then a string date:

Field Paid is format Date

source:

Private Sub Form_Load()
Dim DB As Database
Dim RS As Recordset
Dim DT As String

DT = "3/1/00"

Set DB = OpenDatabase("c:\q.mdb")
Set RS = DB.OpenRecordset("select * from SubScribers")

If RS!PaidThrough > DT Then
q = q
Else
q = q
End If
End Sub

When the value of PaidThrough = 1/3/99 the field is allway greater then DT.

Is there any possibility to convert a string to a date to get a correct answer.

Nice regards,

Michelle.