CHECK DATE VAR in a between fields

[sal21]

I have this VarData=07/01/2020.
i need to check if VarData is in a between from DAL and AL

in my case the result is true

see image.

note:
for SQL in ADo and VB 6.0 and access Database table named FERIE

[HansV]

Does the table FERIE contain only one record?

[sal21]

Does the table FERIE contain only one record?

Sorry, but the real table contain approx 15.xxxx records.

... and the table contain also a field MATR, is a unique Id.

In this my my ... select ... from ... where MATR='" & VarMatr & "'... ecc

[HansV]

Here is some code:

Code: Select all

    Dim cnn As ADODB.Connection
    Dim rst As ADODB.Recordset
    Dim sql As String
    Dim bln As Boolean
    Set cnn = New ADODB.Recordset
    cnn.Open ConnectionString:="..."
    sql = "SELECT Count(*) FROM FERIE WHERE #" & Format(VarData, "mm/yy/dddd") & _
        "# BETWEEN DAL AND AL"
    Set rst = New ADODB.Recordset
    rst.Open Source:=sql, ActiveConnection:=cnn, Options:=adCmdText
    bln = (rst(0) > 0)
    rst.Close
    cnn.Close

[sal21]

Here is some code:

Code: Select all

    Dim cnn As ADODB.Connection
    Dim rst As ADODB.Recordset
    Dim sql As String
    Dim bln As Boolean
    Set cnn = New ADODB.Recordset
    cnn.Open ConnectionString:="..."
    sql = "SELECT Count(*) FROM FERIE WHERE #" & Format(VarData, "mm/yy/dddd") & _
        "# BETWEEN DAL AND AL"
    Set rst = New ADODB.Recordset
    rst.Open Source:=sql, ActiveConnection:=cnn, Options:=adCmdText
    bln = (rst(0) > 0)
    rst.Close
    cnn.Close

this is for me!
Work perfect.
Tks