I got a bit confused with what your problem was.
However, I know that I have had HUGE problems with date formats, with different computers getting different results when using the same asp page and the same database.....
I now try to always format the month in letters.
Here is a bit in asp to help....
><% dim l_Months
l_Months= Array("","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"

%>
.
.
.
<% dt = date()
day = datepart("d",dt)
mnt = l_Months(datepart("m",dt))
yr = datepart("yyyy",dt)
dateone = "'"&mnt&" "&day&" "&yr&"'"
Query = "SP_MY_SP " & dateone
%>