|
Guys,
I have a fail date comparision on my sql statement : month(search.fields("variable"))= m
that don't find the equivalent data.
The variable m, indicte the month number and I use it as reference to the array to print the month name:
month=array("","janeiro","fevereiro","março","abri l", "maio","junho","julho","agosto","setembro","ou tubr o","novemb ro","dezembro")
m=DatePart("m",(date()))
Anyone have some clue to help compare correctly the date in order to select all the data which the field matches with "m" on my db??
Already tried switch = to like, but works ony partialy, cause I have a mismatch on the following situations: 1,11,12 e 10
Also tested the comparision by printing the variables on a test page (they print exactly the same Ex. m=1 and month(search.fields("variable"))=1 )
Also tested the type of data by using the isnumeric test and both returned true.
|
