In my web system I have the following select:
SELECT round(SUM(peso),3) FROM mov02s WHERE modal = ('Carreta simples') AND data = ('2018-05-16')
I'd like to use a variable instead of '2018-05-16'. The user who will choose the date.
I thought of making a date input with javascript:
<input type="date" id="myDate" value="2018-06-26" />
But I still have not been able to evolve. I could not get the variable.