Not everyone has Word on their computer, and even those that do might not be willing to
open documents posted on the web (macro virus threat), and even if they are, there may
be compatibility issues. The best format for posting screenshots is JPEG; yes, it requires
a bit more work to save a "bump" as .jpg, but if you're looking for assistance, it makes it
easier for the folks you want to read the documents to open them.
Date types always have a certain level of imprecision to them -- especially when the database
leaves it to the client app to determine timezone. Equivalence tests are unlikely to result
in a TRUE evaluation unless they are exact to the second (or even millisecond). The safe
way to do date comparisons is to construct a range test ( "datecol >= {date}00:00:00 AND
datecol < {date+1}00:00:00" ). You can sometimes use the BETWEEN SQL operator (e.g.,
"WHERE expr BETWEEN v1 AND v2"), but on some implementations BETWEEN evaluates as
"expr > v1 AND expr < v2", which would miss values equal to v1.
- V
