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

If you have one cell with the =TODAY() formula, then run a macro that copies
and pastes 'Special, Values', this will give you a date that stays the same.
Remember to format the destination cell as Date before pasting.
BCB

"shaqil" wrote:

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

Try the SQL DATE() function. Typically that function returns the current
date to a query:

Example:
SELECT `Sheet1$`.date, `Sheet1$`.party, `Sheet1$`.amount
FROM `C:\tmp.xls`.`Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.date=DATE())

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"shaqil" wrote:

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

On Apr 26, 4:00 am, Ron Coderre
wrote:
Try the SQL DATE() function. Typically that function returns the current
date to a query:

Example:
SELECT `Sheet1$`.date, `Sheet1$`.party, `Sheet1$`.amount
FROM `C:\tmp.xls`.`Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.date=DATE())

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"shaqil" wrote:
Dear All,

I have the following SQL for25-04-07but I want to change it for
today means that if I open it tomorroe then it will show records for
26-04-07not25-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

Thanks a lot Mr Ron, ur SQL is working.

U did the same job that Ron did for Harry in Harry potter & Sorcerer's
Stone.

Thnk U Very Much.