Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try like:
Date(MonthStart(calendarDate),'MMM-YY') as Mydate
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
Thank you its working fine .
its not working. showing blank .