Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a csv data source containing Date column in the format 'DD-MMM-YY eg: 22-Oct-15.
I want to display this dates in the format MMM-YYYY in multibox.
I tries this by using MonthName() function but couldn't find any solution.
Please help me out. Attached is the csv for your reference.
Thanks in advance
Regards
Priyanka
just use function date
date(yourdatefield,'MMM-YYYY')
Hi,
I tried using this but couldn't find the exact solution.
I am not getting any item in the list box.
Regards
Priyanka
use expression in multibox
See if this helps:
SET DateFormat='D-MMM-YY';
Table:
LOAD [Planned Completion Date],
[Revised Completion Date],
MonthName([Planned Completion Date]) as Test1,
MonthName([Revised Completion Date]) as Test2,
Date([Planned Completion Date], 'MMM-YYYY') as Test3,
Date([Revised Completion Date], 'MMM-YYYY') as Test4
FROM
export.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Use below as an expression in MultiBox or ListBox
Date(Date#([Planned Completion Date],'DD-MMM-YY'),'MMM-YYYY')
Hi Manish,
Why are you using Date# function in your expression.
As planned completion date field is number format.
Is there any specific reason to use Date#.........
Thanks,
Naresh
Hi,
I tries using the above expression but it didn't work in my case.
I am getting a empty multibox
Got it.
Thanks Krishna
KR,
Naresh