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

Shaqil,
Assuming your SQL is valid/working, you can use:

....WHERE (`Sheet1$`.date={ts '" & Format(Now(), "yyyy-mm-dd hh:mm:ss") &
"'})"

Note the inclusion of the ' around the date.

NickHK

"shaqil" wrote in message
ups.com...
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 25, 2:24 pm, "NickHK" wrote:
Shaqil,
Assuming your SQL is valid/working, you can use:

...WHERE (`Sheet1$`.date={ts '" & Format(Now(), "yyyy-mm-dd hh:mm:ss") &
"'})"

Note the inclusion of the ' around the date.

NickHK

"shaqil" wrote in message

ups.com...

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

I have just paste your words in SQL as it is. but is not working.

What does "but is not working" mean ?
You have help us as we can see what you doing.

print you SQL string to the Immediate window to see what you actually using.
Was it working before ?

NickHK

"shaqil" wrote in message
oups.com...
On Apr 25, 2:24 pm, "NickHK" wrote:
Shaqil,
Assuming your SQL is valid/working, you can use:

...WHERE (`Sheet1$`.date={ts '" & Format(Now(), "yyyy-mm-dd hh:mm:ss") &
"'})"

Note the inclusion of the ' around the date.

NickHK

"shaqil" wrote in message

ups.com...

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

I have just paste your words in SQL as it is. but is not working.