i want to insert by using subquery from other two tablw but i want to enter fill date column by current date

Question

INSERT INTO initial(name,quantity,Date) select c.name AS Item_Name,b.Ibyinjiye - i.Ibyasohotse AS Current_Stock_QTY from product as c inner join ( select productID, ifnull(sum(quantity),0) as Ibyinjiye from stockproduct group by productID ) as b on c.productID = b.productID inner join ( select productID, ifnull(sum(quantity),0) as Ibyasohotse from soldstock group by productID ) as i on c.productID = i.productID,CURRENT_DATE;