Compare a date field

[filipe26]

Hi i want to compare a date field from the current date.How do i do that in a query?I use paradox through BDE.Thanks.

 

[Svanhooft]

hi,

A query could look like this:

select * from table where datefield = Cast('04-19-2004' as Date)

hope this helps

Steph [Bigglasses]

 

[filipe26]

No it doesn't work.

 

[lespaul]

compare a date field from the current date

You want to see if a field in your table matches today's date?

with qryName do
begin
SQL.Clear;
SQL.Add('SELECT * FROM TABLE WHERE FIELDNAME = ' + FormatDateTime('mm/dd/yyyy', Today));
Active := True;
end;

To see if a field in the query matches today then:

with qryName do
begin
SQL.Clear;
SQL.Add('SELECT * FROM TABLENAME');
Active := True;
if FieldByName('DATEFIELD').AsDate = Today then
begin
//do something
end;
end;

Does that help?

Leslie

 

[filipe26]

ok thanks.