Dear All,

I have the following SQL for 25-04-07 but I want to change it for
today means that if I open it tomorroe then it will show records for
26-04-07 not 25-04-07.

My SQL is :

SELECT `Sheet1$`.date, `Sheet1$`.party, `Sheet1$`.amount
FROM `C:\tmp.xls`.`Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.date={ts '2007-04-25 00:00:00'})

Kindly solve my problem.

Thnx