Sorry I ask this question

From: Franco Jommi (franco.jommmi_at_tin.it)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 10:54:24 GMT

It's incredible, but I can't figure out how to set a stuoìpid filter on a
date, and I have to ask somebody! I need, first to filter out all of the
records with a null expiry date, and then those with an expiry date less
then the current date.
I just need to set the Filter property of my TTable, and I didn't find the
correct way, since in the filter it looks I can't use expressions.
Can you help ? I am stuck!

Relevant Pages

  • Re: Query Criteria to Identify Expired Credit Cards
    ... It would be much simpler to filter your requests using a date field. ... I guess you are storing it in MM/YY format. ... You could then filter using Monthand Yearand display the date field however using Format(). ... Year([C/C Expiry]) ...
    (comp.databases.ms-access)
  • Re: Sorry I ask this question
    ... but I can't figure out how to set a stuoìpid filter on a ... first to filter out all of the ... > records with a null expiry date, and then those with an expiry date less ... I am stuck! ...
    (comp.lang.pascal.delphi.misc)
  • Re: Sorry I ask this question
    ... but I can't figure out how to set a stuoìpid filter on ... >> records with a null expiry date, and then those with an expiry date ... use a Query for stuff ...
    (comp.lang.pascal.delphi.misc)
  • Re: Sorry I ask this question
    ... but I can't figure out how to set a stuoìpid filter on ... >> records with a null expiry date, and then those with an expiry date ... Dave ...
    (comp.lang.pascal.delphi.misc)
  • Plutos Filters (Re: Latest version of !Draw)
    ... Tim Hill muttered: ... expires kill filed entries after 30 days. ... When you set a new filter up it suggests an expiry date of one month ...
    (comp.sys.acorn.misc)