10 Replies Latest reply: Aug 18, 2014 1:56 AM by Enrique Colomer RSS

    MonthName Function Issue in MultiBox

    Girish Talele

      Dear Experts,

      We have a issue of using Function MonthName in MultiBox.

      The sample data is as given below :-

       

      Data1:

      Load * Inline [

      Date, OrdNo

      01.04.2014, Ord 1

      02.04.2014, Ord 2

      03.04.2014, Ord 3

      11.05.2014, Ord 4

      24.05.2014, Ord 5

      24.06.2014, Ord 6

      25.06.2014, Ord 7

      30.07.2014, Ord 8

      31.07.2014, Ord 9

      01.08.2014, Ord 10

      02.08.2014, Ord 11

      03.08.2014, Ord 12

      ];

      //=============================================

      Data2:

      Load

        *,

        MonthName(Date) AS MonthName

      Resident Data1;

      Drop Table Data1;

      //=============================================

       

      If we skip second resident table (Data2) & generate MonthName in MultiBox & if we select SINGLE date in Result Table in the MultiBox is showing value as - "Apr-2014" (refer attached file & snap).

      Please suggest how to tackle this issue.

      Capture.JPG.jpg