Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have date in below format
'V32022001' .
Here format is V3&YYYY&0&01...last 2 digits are month number.
I want to show this as Apr 22 in MMM YY format.
Tried using following but no output is coming up.
DATE(date#($(vPeriod),'V3YYYY0MM'),'MMM YY');
How to resolve this?
Hi, maybe
=date(MakeDate(left(right('$(vPeriod)',7),4), right('$(vPeriod)',2)) ,'MMM YY')