Hello,
I have a table with three columns for example.
Eg: Table A with id, name and date (columns)
Data Type for the columns is
id - int
name - varchar
day - varchar
I performed a date range parameter but it didn’t work…
I did,
SELECT id, name, date_format(str_to_date(day, ‘%d/%m/%Y’), ‘%m/%d/%y’) as day from v_dashboard
where day between ‘{{ duration.start }}’ and ‘{{ duration.end }}’.
But for the text field it is working.
I could not understand why for the date range is not working and returns a empty table.