View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christina Christina is offline
external usenet poster
 
Posts: 66
Default Date problem in a SELECT sql statement

Hi everyone,

I have a problem that I cannot figure out , please help me.
I have a colum J that contain the date such as 25/9/2005 0:00:00 (those date
come from a select in my Access database). Then, I want to use those date in
another select as follow:
SQL.REQUEST(Conx,,4,"Select mesure from piezo where no_site like '" & $M$14
& "' and date_piezo = DATEVALUE(" & J23 & ")")
As I know, this SELECT must return the mesure value, However it does not
return any value.

Any help will be appreciated
Regards,