Date HELP

[Guest_imported]

Hi, I'm using Delphi5 and I have a SQL query retreiving appointments where the date is greater than Today. The funcion Date in delphi returns the current date(if I'm not wrong). I tried everything but I keep getting type mismatch error or invalid use of keyword Date...

'select * from traitements where Datefield > DateToStr
(Date) order by datefield'
or
maintenant := DateToStr(Date);
'select * from traitements where Datefield > '+maintenant+' order by Datefield'
It never works
Please help
Thanks [sig][/sig]

 

[bigscouse]

I am not a delphi5 expert but it looks to me like you are comparing a char string with a date and they may be uncompatible. [sig]<p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>Top man[/sig]