year month issue

[soniasweety]

Hi All,

i have a date  column   

calendarDate

11/01/2019

11/02/2019

12/01/2020

10/01/2019

so i want output  like   

Oct-19  

Nov-19

Dec-20 

i used below  but im getting   

 Date(calendarDate,'MMM-YY')  as Mydate

but result in listbox i can seee

Oct-19

0ct-19

oct-19

Nov-19

Nov-19  

months is showing duplicates   .. usaally listbox show distinct values right?

[tresB · Accepted solution]

Try like:

 Date(MonthStart(calendarDate),'MMM-YY')  as Mydate

[karthiccr]

Hi,

The data is still interpreted as Date type. try converting to String using TEXT.

Text(Date(Date#(F1,'DD-MM-YYYY'),'MMM-YY')) as MMMYY;

Thanks,

karthik

[soniasweety]

Thank you its working fine . 

[soniasweety]

its not working.   showing blank .