I am trying to apply a filter like

MyTable.Filter := 'aDate='+QuotedStr(FormatDateTime('yyyy-mm-dd', Now()));

But I am getting an error "Invalid Date Expression"

Is it the format I am putting the date in?

Thank you

Dave

> MyTable.Filter := 'aDate='+QuotedStr(FormatDateTime('yyyy-mm-dd', Now()));

In EDB you have to define the date-type like this:

MyTable.Filter := 'Datum = date ' +
QuotedStr(FormatDateTime('yyyy-mm-dd', Now()));

In you case it would be simpler to use:

MyTable.Filter := 'Datum = Current_Date';

Regards Uli

Uli Becker <test@test.com> wrote:

Dave

> MyTable.Filter := 'aDate='+QuotedStr(FormatDateTime('yyyy-mm-dd', Now()));

In EDB you have to define the date-type like this:

MyTable.Filter := 'Datum = date ' +
QuotedStr(FormatDateTime('yyyy-mm-dd', Now()));

In you case it would be simpler to use:

MyTable.Filter := 'Datum = Current_Date';

Regards Uli

Brilliant. Thank you very much.