• Registered: 2014-08-12
  • Posts: 4

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?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Search between dates

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:

Post's attachments

Attachment icon Employees.zip 4.66 kb, 605 downloads since 2014-08-18 

Dmitry.
  • Registered: 2014-08-12
  • Posts: 4

Re: Search between dates

Thank you very much. How can I change the date-format in the results?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Search between dates

Date format you can change in Panel Control > Regional and Language

Dmitry.