Is there any iformation on date functions with C/ODBC for Navision Financials 2.60? I am trying to extract the weeknumber out of a date field.
From which application are you connecting to a Navision database through ODBC? Kind regards, Jan Hoek Weha Automatisering BV Woerden - The Netherlands
I am connecting to Navision with COGNOS Software (Impromptu). There is a way to edit your SQL statement in this tool, so I am looking for the statement that lets me extract the weeknumber from a date field. The function week(date) does not work.
The WEEK-function would have been my first (and only…) guess as well, based on the information in the on-line help file for ODBC that Microsoft ships with the MDAC 2.6 SDK. Kind regards, Jan Hoek Weha Automatisering BV Woerden - The Netherlands