Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have following expression label
='Refunds' & ' '&(ONLY(C_YEAR_MONTH)) and resulting output is Refunds 1-2014
But want this output to appear as Refunds Jan-14
pls help me to modify the above expression label to display the desired result
='Refunds' & ' '&Date(Date#((ONLY(C_YEAR_MONTH)),'M-YYYY'),'MMM-YY')
='Refunds' & ' '&Date(Date#((ONLY(C_YEAR_MONTH)),'M-YYYY'),'MMM-YY')
Try,
='Refunds' & ' '&MonthName(ONLY(C_YEAR_MONTH))
Or
='Refunds' & ' '&Date(Date#(C_YEAR_MONTH),'M-YYYY'),'MMM-YY')
Regards,
Tks