topic Date Conversion Format in QlikView

Date Conversion Format

Thu, 23 Apr 2015 20:27:51 GMT

Hi All,

I have a variable declared

vCurrentMonthYear = 012015;

Using the above variable am able to retrieve the month and year as shown below

Upper(Date(MakeDate(RIGHT($(vCurrentMonthYear), 4), LEFT($(vCurrentMonthYear), 2)), 'MMM YYYY'));= JAN 2015

Now, how can i get "Jan-2015" using the same variable.

Thu, 23 Apr 2015 20:40:34 GMT

Hi,

Try:

=Dual(Month(Date#(vCurrentMonthYear,'MMYYYY'))&'-'&Year(Date#(vCurrentMonthYear,'MMYYYY')),Date#(vCurrentMonthYear,'MMYYYY'))

Hope this helps.

Kind regards,

Nuno

sunny_talwar — Thu, 23 Apr 2015 20:41:23 GMT

Try this:

Date(MakeDate(RIGHT($(vCurrentMonthYear), 4), LEFT($(vCurrentMonthYear), 2)), 'MMM-YYYY')

MonthName(Date(MakeDate(RIGHT($(vCurrentMonthYear), 4), LEFT($(vCurrentMonthYear), 2)), 'MMM YYYY'));

Fri, 24 Apr 2015 17:25:28 GMT

Thanks for your quick response.

Fri, 24 Apr 2015 17:26:00 GMT

Thanks for your quick response.

sunny_talwar — Fri, 24 Apr 2015 17:26:48 GMT

No problem, I am glad it worked

Best,

Sunny

MarcoWedel — Fri, 24 Apr 2015 22:45:50 GMT

Hi,

another possibility could be:

=Date(Date#(vCurrentMonthYear,'MMYYYY'),'MMM-YYYY')

hope this helps

regards

Marco