Lotus NotesSQL Year function usage

I am trying to use the YEAR function in a query going against a Lotus Notes database via ODBC.  Here is example 1:

SELECT StartTimeDate,
	StartDate,
	YEAR(StartDate)
FROM MainTopic
WHERE StartDate >= '2014-03-01'

Open in new window

The results are:
[Lotus][ODBC Lotus Notes]Name, constant, or expression expected

[Lotus][ODBC Lotus Notes]Incorrect syntax near ','

[Check aborted]


In example 2 I removed the line with the YEAR function:
SELECT StartTimeDate,
	StartDate
FROM MainTopic
WHERE StartDate >= '2014-03-01'

Open in new window


The result is:
[Command checked successfully]
so the query will run.


Also, is there any good documentation on using NotesSQL?  I haven't found any, but would be grateful for any hints.
LVL 2
Alan VargaAccess DeveloperAsked:
Who is Participating?
 
Sjef BosmanConnect With a Mentor Groupware ConsultantCommented:
Probably the YEAR function isn't implemented. NotesSQL is only a very basic way to execute SQL-like queries on a Notes database. See also the documentation...

Ah, yes, that's your 2nd Frage: http://www.ibm.com/developerworks/lotus/documentation/notessql/
0
 
Alan VargaAccess DeveloperAuthor Commented:
That's what I was afraid of; my workaround is to use 'macro' as "StartYear" and handle it in Excel with VBA.

Vielen Dank!
0
 
Alan VargaAccess DeveloperAuthor Commented:
The answer came back quickly and to the point, with a helpful link.  Thanks very much Experts Exchange!
0
 
Sjef BosmanGroupware ConsultantCommented:
Bitte sehr.  :-)
0
All Courses

From novice to tech pro — start learning today.