4 Replies Latest reply: Jun 12, 2014 9:04 AM by Tobias Meyer RSS

    How can I separate the DateFormat from Source ODBC? for Dashboads


      I want to work with my Database

      After Connecting and Selecting (SQL), I want to create new objects like dates by separating this.

      How can I separate the "Posting Date" in Month, Year and other Combination?

      Should I use the function in Script or  via Listbox ?


      CONNECT TO Navision;

      SQL SELECT "Posting Date",

      FROM "DB.X.Y";