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"
My Visual Database → SQL queries → 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"
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.
Thank you very much, that's what I needed
Wen.
My Visual Database → SQL queries → How to filter data by date range
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi