Discussion board where members can get started with QlikView.
The field is named ship_(shdate. It looks like 3/14/11, 4/01/10...
I want it to look like Jan, Feb, Mar ...
When I do MonthName(ship_date) I get 4.06+e....
When I do Month(ship_date), I get #'s.
I suspect this is easy, but after and hr of searchign the forum, I still don't know how to sold this.
I believe the field first must be recognized and imported as a date, and you must ensure that the date formatting option or functions reflect what you want.
Could you attach of copy of your data and application file?
Month(Date#(Ship_date,'MM/DD/YYYY')) - yeilds nothing
Month(Date#(Ship_date,'MM/DD/YY')) - yeilds nothing
Month(Date(Ship_date,'MM/DD/YY')) - yields '1', '3', '5' ....
apprentice's method works, but I think if your DateFormat is set in a different format than what you have in your DB you can use the following:
Month(Date#(Ship_date, 'MM/DD/YY')) as MonthName
If this doesn't solve your problem, something else is wrong. It works for me in my QV10 and also for apprentice.
Here's how I did it for a field that I had as Period (represented by the ,1)
dual ( string,Period ) as [Fiscal Month] inline
Period, Period as [Fiscal Month]
FROM [\\MANNETAPP01\BST_Shared_Folder\FY12\ATF\OPEX\FY12 Opex Reporting Q2.xlsx]
(ooxml, embedded labels, table is data);