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.

[ecolomer]

I agree with Ashfaq Mohammed