delphims-accessfiltertadotable

How do you apply a Delphi ADOTable filter to a date data type

in MS Access I am able to filter a date in a query like this: ex.

SignUpDate > #31/12/2013#

this will make the database only show records where SignUpDate is in 2014 or newer

How will I do this in delphi?

dmGym.tblMembers.filter := 'SignUpDate > ''#31/12/2013#''' doesn't seem to work

please help it wil be greatly appreciated

Solution

  • Try dmGym.tblMembers.filter := 'SignUpDate > #yyyy/mm/dd#' (2013/12/31)

    -credit to kobik's comment