I’m trying to use NotesSQL to query tables in Notes and produce an excel report. I’m finding the SQL very limited. I’ve tried using things like DATEDIFF and different types of JOINS and get errors.
Am I correct in thinking that NotesSQL is very basic and can’t handle any complex SQL or am I missing something?
Subject: Notes2SQL
My answer is a bit too late 
but maybe I can help someone else with it. Feel free to check out our Notes to SQL application, server based, not just a driver, to transfer Lotus Notes to SQL or any other ODBC supported database system.http://www.lialis.com/Applications/EnglishSite.nsf/dx/Notes_to_SQL