Re: AW: Date failing issue in SQL

<snip>
If you want to compare a numeric date with the current date in your
program.
It would be far better to convert the current date into a numeric
representation outside the SQL statement, store it in a Host variable and
use this host variable within your SELECT-Statement.
Alternatively a global variable could be used to hold the numeric current
date.
</snip>

And now, Chuck Pence, Birgitta, and I have all suggested to NOT manipulate
the code on the left
and date(varchar( integer(T01.IATRND/10000)) || '-' ||
varchar( integer(T01.IATRND/100)
- integer(T01.IATRND/10000) * 100 ) || '-' ||
varchar(mod(T01.IATRND, 100))
) = current date
but instead to do
...
t01.iatrnd=int(current date)
or Birgitta's
DateSelection = int(current date)
...
t01.iatrnd=:DateSelection

And not just because it's simpler but because it performs much better.

Rob Berendt