I have been trying to use the values from two datepickers to filter my data in sqlite. My date column has datepicker value formated as 'DD-MM-YYYY', when i use datepicker values with BETWEEN, I get data filtered but only by DD range. I have tried to use some date functions i.e to_date() and DATEPART() with my BETWEEN but without success
What is the best way of extracting dates between two datepicker values given that it gets posted as text in my date column?
help much appreciated.