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
Did you look at the script I provided above? May be that helps?
HI,
Try something like this,
Date(date#([Revised Completion Date],'DD-MMM-YY'),'MMM-YYYY') as MonthAndYear
Hello Priyanka,
Did you try using Sunny's script or qvw file he sent??
Can you send us your qvw file where you cant see the dates in Multibox here.
Thanks,
V.
Rudolf,
I would think your solution would work. But I suggest adding MonthStart() to generate only one row per MMM-YYYY value.
=date(MonthStart(yourdatefield),'MMM-YYYY')
-Rob
Hi,
I tried you script and its dosent work for me.
belowis the screenshot for your reference.
HI ,
please find the attached applicaiton
That's because your Date field values are not read in as dates (i.e. intepreted as dates by QV and having a numeric representation).
Your date format seems to be 'DD/MMM/YY' instead of 'DD-MMM-YY'.
Try to adapt your code with the correct input value format.
SET DateFormat = 'DD/MMM/YY';
Note that two digit year format is ambiguous, might lead to some 'wrong' 4 digit year values when QV tries to intepret these values.
edit:
See also
Hi,
Thank you very much.
It solved my problem
Thanks once again
Regards
Priyanka
Hey Priyanka,
Can you close the thread by marking as Helpful or Answered if it resolved your issue.
Many thanks,
V.