Sqlite and setting it between dates, Format Correct but still not working

So I'm trying to get a basic sql string to work where it will grab the records in the sqlite database based on between dates. However, for some reason, it doesn't work. I just don't understand why.

private void viewTransactionsBetweenDatesTable(){
    //Sets the table to view transactions between certain dates

    try{
        //Get's the dates from startDateChooserTransactions1 and endDateChooserTransactions1
        DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        DateFormat df2 = new SimpleDateFormat("MMM dd, yyyy");
        Date sdct = startDateChooserTransactions1.getDate();
        Date edct = endDateChooserTransactions1.getDate();
        String sdcts = df.format(sdct);
        String edcts = df.format(edct);
        String sdctlabel = df2.format(sdct);
        String edctlabel = df2.format(edct);

        //Child's ID
        String cid = childIDCheck1.getText();

        //Grab's the specified data and places that as the table
        String sql = "SELECT * FROM ChildrenPayment WHERE ChildID='"+cid+"' AND strftime('%Y-%m-%d', 'Report Transaction Date') BETWEEN '"+sdcts+"' AND '"+edcts+"' ";
        pst = conn.prepareStatement(sql);
        rs = pst.executeQuery();

        //Sets up the table
        Info1.setModel(DbUtils.resultSetToTableModel(rs));    
        TableColumnModel tcm = Info1.getColumnModel();
        //tcm.removeColumn(tcm.getColumn(3));
       // tcm.removeColumn(tcm.getColumn(3));
       // tcm.removeColumn(tcm.getColumn(10));
       // tcm.moveColumn(11, 10);
       // tcm.removeColum(tcm.getColumn(13));

        //Changes modLabel1
        modLabel1.setText(firstNameEditClass1.getText() + " " + lastNameEditClass1.getText() + " Between " + sdctlabel + " - " + edctlabel);

    }catch(Exception e){
        JOptionPane.showMessageDialog(null, e);
    }finally{
        try{
            pst.close();
            rs.close();
        }catch(Exception e){
            JOptionPane.showMessageDialog(null, e);
        }
    }
}

I am using a jdatechooser so I am sort of forced to use SimpleDateFormat compared to the better DateTimeFormatter. Anyway, I'm formatting it according to YYYY-MM-DD like sqlite likes, but when I run the function, the table does not display anything. I set the days pretty wide (Feb 01, 2018 to Feb 14, 2018) and the date in my database is Feb 07, 2018. I have a few records in the database for it to pull. However, it just doesn't do it. And no error is popping up, so I do not know why it is not working.

Image of the records that I'm trying to place into my jtable

Edit1: Before I forget, I also tried the following SQL string

String sql = "SELECT * FROM ChildrenPayment WHERE ChildID='"+cid+"' AND 'Report Transaction Date' BETWEEN '"+sdcts+"' AND '"+edcts+"' ";

Solution

This will not work:

strftime('%Y-%m-%d', 'Report Transaction Date')

because the format specifiers you have provided require that you supply three values, one each for year, month, and day.

If the dates in the database are stored as complete SQLite datetime strings, you will have to use

"... date([Report Transaction Date]) BETWEEN '"+sdcts+"' AND '"+edcts+"' ";

Note square brackets (not single quotes) around column name. This has nothing to do with needing a date/time value, it's because the column name has spaces in it. Any column name with spaces has to be enclosed in double quotes or square brackets. That's why it's a good idea to never use spaces in column names.

If they are, in fact, stored as 'YYYY-MM-DD' strings, then the reason your alternative didn't work is because you single-quoted the column name 'Report Transaction Date', which results in comparing that literal string to the date values.