Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
maybe
='Current Month' &'-'& Month(max(Date))
Load Date,
Date(Month(Date),'MMM') as Month
From...
another one
'Current Month' & ' - ' & Month(Date#(Max(Month), 'M'))
='Current Month' &'-'& MaxString(Month)
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)