I am having trouble trying to get the date picker to show up when I set up parameters for a user to run. It does not seem to be showing them. Below is my code. Any help on the matter would be great thanks!
DROP PROCEDURE IF EXISTS sp_DBR_IMP_VIEWS
$$
CREATE PROCEDURE sp_DBR_IMP_VIEWS
( StartDate date, EndDate date,inLogin varchar(30))
BEGIN
select c.viewed_vin as 'VIN',
c.viewed_year as 'Year',
c.viewed_make as 'Make',
c.viewed_model as 'Model',
COUNT(c.viewed_vin) as 'Views'
from cs_tracking.cs_inventory_tracking c
where c.dealer_id = '1000002' AND c.viewed_date BETWEEN StartDate AND EndDate
group by c.viewed_vin;
END
$$