Date Conversion Format

[#1]

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.

[#2]

Hi,

Try:

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

Hope this helps.

Kind regards,

Nuno

[sunny_talwar · Accepted solution]

Try this:

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

or

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

[#4]

Thanks for your quick response.

[#5]

Thanks for your quick response.

[sunny_talwar]

No problem, I am glad it worked

Best,

Sunny

[MarcoWedel]

Hi,

another possibility could be:

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

hope this helps

regards

Marco