Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
Date(MakeDate(RIGHT($(vCurrentMonthYear), 4), LEFT($(vCurrentMonthYear), 2)), 'MMM-YYYY')
or
MonthName(Date(MakeDate(RIGHT($(vCurrentMonthYear), 4), LEFT($(vCurrentMonthYear), 2)), 'MMM YYYY'));
Hi,
Try:
=Dual(Month(Date#(vCurrentMonthYear,'MMYYYY'))&'-'&Year(Date#(vCurrentMonthYear,'MMYYYY')),Date#(vCurrentMonthYear,'MMYYYY'))
Hope this helps.
Kind regards,
Nuno
Try this:
Date(MakeDate(RIGHT($(vCurrentMonthYear), 4), LEFT($(vCurrentMonthYear), 2)), 'MMM-YYYY')
or
MonthName(Date(MakeDate(RIGHT($(vCurrentMonthYear), 4), LEFT($(vCurrentMonthYear), 2)), 'MMM YYYY'));
Thanks for your quick response.
Thanks for your quick response.
No problem, I am glad it worked
Best,
Sunny
Hi,
another possibility could be:
=Date(Date#(vCurrentMonthYear,'MMYYYY'),'MMM-YYYY')
hope this helps
regards
Marco