Quote:
Originally Posted by Velocd
date() function returns a human readable representation of a timestamp.
So comparing its return value to a timestamp (joindate) is erroneous.
|
OOOOoohhhhhhh...... I get it! Even though I'm seeing the result of the date function returning the value I want the WHERE clause is still comparing the real value of joindate versus my criteria. OK, that's a little different from some environments I'm used to.
OK, off to some quick trial & error.....
Thanks!
Kevin