How to get Month in Jan,Feb Format in Text Object

[bhavvibudagam]

Hi Every one,

Can any one please help me on below issue.

I have one Date Field. From the Date Field I have derived the Month field from Date Field like below.

Load  Date,

          Month(Date) as Month

From

......

Then I have taken the Maximum Month as like below in Text Object

='Current Month' &'-'& Max(Month)

Got the Result as 12 instead of Dec. How to get the Month in the Dec format instead of 12.

Thanks,

[maxgro]

maybe

='Current Month' &'-'&  Month(max(Date))

[Frank_Hartmann]

Load  Date,

          Date(Month(Date),'MMM') as Month

From...

[maxgro · Accepted solution]

another one

'Current Month' & ' - ' & Month(Date#(Max(Month), 'M')) 

[antoniotiman]

='Current Month' &'-'& MaxString(Month)

[its_anandrjs]

And another way just add this line in your table

if(Month = Month(Today()),1,0) as Flag

Final:

LOAD *,

Month(Date) as Month,

if(Month = Month(Today()),1,0) as Flag

From Source;

And On front end in text object

='Current Month' &'-'& Only( {<Flag={1}>}Month)