Database

SELECT 
a.project_no, 
a.status, 
a.Sales_no, 
a.swan_job, 
b.tc, 
b.EC, 
convert(VARCHAR(10), b.startup_check_date, 120), 
convert(VARCHAR(10), b.finished_check_date, 120), 
e.Employee_ID, 
e.fname, 
e.lname, 
c.customer_no, 
c.lname, 
c.fname 
FROM project AS a, commission_summary AS b, employee AS e, customer AS c 
WHERE a.project_no = b.project_no 
AND a.customer_no = c.customer_no AND a.sales_no = e.Employee_ID 
AND (a.status = 'construction' OR a.status = 'finished') 
AND (convert(VARCHAR(10), b.startup_check_date, 120) BETWEEN '2021-4-01' AND '2021-4-31') 
OR (convert(VARCHAR(10), b.finished_check_date, 120) BETWEEN '2021-4-01' AND '2021-4-31') 
OR (convert(VARCHAR(10), b.startup_check_date, 120) IS NULL 
OR convert(VARCHAR(10), b.startup_check_date, 120) = '1900-01-01') 
OR (convert(VARCHAR(10), b.startup_check_date, 120) < '2021-4-01') 
AND (convert(VARCHAR(10), b.finished_check_date, 120) IS NULL OR convert(VARCHAR(10), b.finished_check_date, 120) = '1900-01-01') 
ORDER BY a.status, b.finished_check_date, b.startup_check_date 

SELECT
    a.project_no,
    a.status,
    a.Sales_no,
    a.swan_job,
    b.tc,
    b.EC,
    convert(CHAR(10),
    b.startup_check_date,120),
    convert(CHAR(10),
    b.finished_check_date,120),
    e.Employee_ID,   
    e.fname,
    e.lname,   
    c.customer_no,
    c.lname,
    c.fname
FROM project as a, commission_summary as b,  employee as e , customer as c
WHERE a.project_no=b.project_no
AND a.customer_no=c.customer_no
AND a.sales_no = e.Employee_ID
AND (a.status ='construction' or a.status ='finished')
AND ((CAST(FLOOR(CAST(b.startup_check_date AS FLOAT))AS DATETIME) BETWEEN '$firstDate' AND '$lastDate')
OR (CAST(FLOOR(CAST(b.finished_check_date AS FLOAT))AS DATETIME) BETWEEN '$firstDate' AND '$lastDate')
OR (b.startup_check_date is NULL  or b.startup_check_date = '1900-01-01')
OR ((CAST(FLOOR(CAST(b.startup_check_date AS FLOAT))AS DATETIME) <  '$firstDate' )
AND (b.finished_check_date is NULL or b.finished_check_date = '1900-01-01')))";

String sQuery1 = "SELECT * FROM service_schedules WHERE (vehicle_id,service_id) IN (SELECT DISTINCT vehicle_id,service_id FROM services_performed) AND vehicle_id=?";
Cursor cursor1 = db.rawQuery(sQuery1, new String[]{ String.valueOf(id) });

String sQuery2 = "SELECT * FROM service_schedules WHERE (vehicle_id,service_id) IN (SELECT DISTINCT vehicle_id,service_id FROM services_performed) AND vehicle_id="+id;
Cursor cursor2 = db.rawQuery(sQuery2, null);

String sQuery3 = "SELECT * FROM service_schedules WHERE (vehicle_id,service_id) IN (SELECT DISTINCT vehicle_id,service_id FROM services_performed)";
Cursor cursor3 = db.rawQuery(sQuery3, null);

Error Message:
Array ( [0] => Array ( [0] => 42000 [SQLSTATE] => 42000 [1] => 260 [code] => 260 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Disallowed implicit conversion from data type smalldatetime to data type float, table 'commission_summary', column 'startup_check_date'. Use the CONVERT function to run this query. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Disallowed implicit conversion from data type smalldatetime to data type float, table 'commission_summary', column 'startup_check_date'. Use the CONVERT function to run this query. ) ) 

getSalesBonusByDate 362: SELECT count (a.project_no) FROM project as a, commission_summary as b WHERE a.project_no = b.project_no AND (a.sold_date <= 3-1-2021) AND (a.status = 'construction' or a.status = 'finished') AND ((CAST(FLOOR(b.startup_check_date)AS DATETIME) BETWEEN 1-1-2021 AND 3-1-2021)) AND a.sales_no = '79' 1

SELECT count (a.project_no) FROM project as a, commission_summary as b WHERE a.project_no = b.project_no AND (a.sold_date <= 3-1-2021) AND (a.status = 'construction' or a.status = 'finished') AND ((CAST(FLOOR(b.startup_check_date)AS DATETIME) BETWEEN 1-1-2021 AND 3-1-2021)) AND a.sales_no = '79' 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;

namespace Stepping
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void btnSave01_MouseClick(object sender, MouseEventArgs e)
        {
            TextWriter writer = new StreamWriter(@"H:\proj\_Programacao\_Arduino\ArduinoHM\Stepper_Polling_us\WinApp\M01.txt");
            
            for (int i = 0; 1 < dataGridViewMotor1.Rows.Count - 1; i++)
            {
                for (int j = 0; j < dataGridViewMotor1.Columns.Count; j++)
                {
                    if (j == 0)
                    {
                        writer.Write(dataGridViewMotor1.Rows[i].Cells[j].Value.ToString());  
                    }
                    else
                    {
                        writer.Write("," + dataGridViewMotor1.Rows[i].Cells[j].Value.ToString());
                    }
                }
            }
            writer.Close();
            MessageBox.Show("Data Exported");
        }

        private void btnFillTestData_MouseClick(object sender, MouseEventArgs e)
        {
            // Line, Abs, Rel, X, C_t, C_i, C_n, MinSpeed, MaxSpeed, Accel, Decel
            dataGridViewMotor1.Rows.Add(1,0, 120,0,0,0,0, 10, 100, 0.9, 0.9 );
            dataGridViewMotor1.Rows.Add(2,0,120, 0, 0, 0, 0, 10, 100, 0.9, 0.9);
            dataGridViewMotor1.Rows.Add(3,0, 80, 0, 0, 0, 0, 10, 100, 0.9, 0.9);
        }
    }
}