mjunior
Newbie
Joined: November/06/2004
Location: Brazil
Online Status: Offline
Posts: 27
|
| Posted: January/18/2006 at 7:25pm | IP Logged
|
|
|
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","abril", "maio","junho","julho","agosto","setembro","outubro","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.
__________________
mjunior(dumb)
|
Active Topics
Memberlist
Search
Help
Register
Login
Topic: date comparision
