• Registered: 2017-05-15
  • Posts: 722

Topic: FILTER by DATE

Hello MVD!

I have a union query of 4 tables then i want a filter via date.  I need help to do this problem.

Thanks!

manixs

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

Re: FILTER by DATE

Hello.


Example:

SELECT DateField, Country FROM Customers
WHERE date(DateField)=date({DateTimePickerFrom})

UNION

SELECT DateField, Country FROM Suppliers
WHERE date(DateField)=date({DateTimePickerFrom})
Dmitry.
  • Registered: 2017-05-15
  • Posts: 722

Re: FILTER by DATE

Thanks DriveSoft.. I Got it noW.

THANKS!