the functiion is like this (correction):
' arnelgpPublic
Function MSSQLDateTime2ToDate(ByVal e As Variant) As Variant
    Dim i As Integer
    If IsNull(e) Then
        MSSQLDateTime2ToDate = Null
        Exit Function
    End If
    i = InStr(1, e, ".")
    If i <> 0 Then
        e = Left$(e, i - 1)
    End If
    MSSQLDateTime2ToDate = DateValue(e) + TimeValue(e)
End Function
now create first a query(query1):

SELECT MSSQLDateTime2ToDate([theSQLDateFieldHere]) AS MSADate, *
FROM linkedTableNameHere;


then create the needed query (query2, your final query):

SELECT * FROM query1 Where [MSADate] >= Date() + 1;