Re: Select string with TODAY
> SELECT * FROM table WHERE date <= TODAY How can I convert TODAY in a> numerica integer 960625 (=YYMMDD)?
> The numeric field date contains the date's in the format. Example: 960625
> for 25th June 1996
>
Try something like this:
SELECT * FROM table
WHERE date <= (((YEAR(TODAY) - 1900) * 10000) + MONTH(TODAY) * 1000 +
DAY(TODAY))
-------------------------
Carlos Antonio Ruiz G'mez
dmys2@colomsat.net.co
Colombia, SurAm'rica