Topic: Search between dates
I have a table with a DATE field, and I would like to make a search between two dates.
I guess I must use an SQL QUERY action, but how can I refer to a date from a DateTimePicker object in the SQL query?
My Visual Database → General → Search between dates
I have a table with a DATE field, and I would like to make a search between two dates.
I guess I must use an SQL QUERY action, but how can I refer to a date from a DateTimePicker object in the SQL query?
You can do it without SQL query.
Place two components DateTimePicker and using property of component Filter
where you should select value >= and <=
Please, download example here:
Thank you very much. How can I change the date-format in the results?
Date format you can change in Panel Control > Regional and Language
My Visual Database → General → Search between dates
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi