I want to check my expire date from my database. But I think my syntax in wrong.
here’s my code.

try
            {
                MySqlConnection con = new MySqlConnection(conn);
                connect.Open();
                string sql = "SELECT schedule FROM db_vehicle_maintenance_schedule where date(date) = date(now())";
                MySqlDataAdapter da = new MySqlDataAdapter(sql, DBConnection.con);
                DataTable ds = new DataTable();
                da.Fill(ds);
                //datagrid.DataSource = ds;

            }
            catch (Exception ee)
            {
               MessageBox.Show(ee.Message);
            }

please help me what is the best syntax to check expired date in my database,
Thank you so much.