Field date

HCL Domino Domino Forum
1

hello,I need to separate the date field in month and year, obviously using NotesSql 8. I have tried with the function Substring describe in this link: http://www-01.ibm.com/support/docview.wss?uid=swg21101519 , but date field is not supported. Is there a solution ? another function?

ps I have tried also with NotesSql 3.02i and Lotus Notes 7

Thank you very much

2

Subject: as mentioned in the technote you cite…

…these functions are not supported by Lotus. You must consult the ODBC documentation to find the correct function to use for extracting the components of a date. Substring, I assume is not working because the value is not a string.