Date in code to SQL - something wrong, but what?

[Makelei]

Hi,
please help me!

I have made a VBA code to form SQL:
This is working OK:
BLASql = BLASql & " HAVING (((Calendar.Day) Between #25/7/2007# And
Date()+1));"

But I need to have date changing (=> wkStartBLA), so this is the latest one
and is NOT working:
BLASql = BLASql & " HAVING (((Calendar.Day) Between #" & Format(wkStartBLA,
"dd/mm/yyyy") & "# And Date()+1));"

I do hate these date formats! Could you please help me to fix this - thanks.
MakeLei

 

[Alex Dybenko]

Hi,
in order to be properly recognized you need to pass date as #mm/dd/yyyy#, so
your SQL should look like:

BLASql = BLASql & " HAVING (((Calendar.Day) Between #" & Format(wkStartBLA,
"mm\/dd\/yyyy") & "# And #" & format(Date()+1,"mm\/dd\/yyyy") & "# ));"

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Makelei]

Hi & thanks Alex once again ;o)
I was quite close in my experiments, but not quite there - now it works.
BR
MakeLei