Topic: How to filter data by date range

Hi, I want to filter this data for a given date range. I think the query is wrong, can someone help me?

SELECT *
FROM fechas
WHERE fecha BETWEEN "DateTimePicker1" AND "DateTimePicker2"  
Post's attachments

Attachment icon dates.zip 333.74 kb, 519 downloads since 2017-12-05 

2 (edited by derek 2017-12-06 11:12:02)

Re: How to filter data by date range

Hi Wenchester,
Please see attached for the way to do it (well, the way that I know - there may be others - LOL!).
Is there any reason why you can't use a 'search' rather than SQLQuery?  I've done both ways in the attachment so you can compare (the 'search' option happens incrementally, the 'sqlquery' needs you to click the button) .
Regards,
Derek.

Post's attachments

Attachment icon dates fixed.zip 336.91 kb, 776 downloads since 2017-12-06 

Re: How to filter data by date range

Thank you very much, that's what I needed

Wen.