topic Re: Date Converting in QlikView

Date Converting

Fri, 02 Aug 2013 09:52:56 GMT

Hello people

I have month and date in 2 separate columns on a spread sheet but want a MonthName (Jan 2013)

I have already converted month into a proper date (Month(Date#((Left(Month,3)),'MMM')) as Month,) and year (Year(Date#(Year,'YYYY')) as Year,)

Now how can I combine the 2 to from a MonthName?

Thanx

tresB — Fri, 02 Aug 2013 10:19:09 GMT

try this:

MonthName (Date#(Left(Month,3)&Year, 'MMMYYYY')) as MonthName

Fri, 02 Aug 2013 10:25:15 GMT

It worked perfectly!!!

Thank You!!!