Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Invalid Date Expression in Filter? |
Wed, May 7 2008 10:59 PM | Permanent Link |
Dave | 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 |
Thu, May 8 2008 3:26 AM | Permanent Link |
Uli Becker | 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 |
Thu, May 8 2008 3:42 AM | Permanent Link |
Dave | 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. |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |