Over the last couple of days we have had a couple of support issues raised with regards to dates and in particular dates when selecting data from OpenInsight based systems. Research has shown that this is actually a potential issue that dates back to the early ARev days and it is only now biting a few people.
If you find that you are getting strange select results, please check out the Sprezzatura blog posting below. Even if you are not having any date or select related issues, this is well worth a read if you are an OpenInsight developer or involved with an OpenInsight system in any way.
Y2K Redux – Indexing Issues With Dates OR 20100 – A Search Oddity.
Martyn's RevSoft UK Blog 