Change the format of Year field

[hopkinsc]

hi all,

i have a field in the format of 'YYYYYY' (201112), i want to change the format so it adds in a '/' (2011/12)

Can anyone help with this please?

[ashfaq_haseeb · Accepted solution]

Hi,

=Left(201112,4)&'/'&Right(201112,2)

Replace 201112 with your field name

Regards

ASHFAQ

[its_anandrjs]

Update

What is mean by YYYYYY it is for year or some thing else.

May be it is a fiscal year is so then try one of the ways

Left(YourField,4)&'/'&Right(YourField ,2)

Or

Date#(Left(YourField,4),'YYYY') & '/' & Date#(Right(YourField ,2),'YY')

[javier_florian]

Hi Hopkinsc,

Your format is wrong, when you apply this format a date field, you can only get 002014 for example... Your case maybe with format YYYYMM, so can you try applying 'YYYY/MM'.

-JFlorian

[hopkinsc]

ho, no, the format is this year last year (201413) - similar to fiscal year.

Thanks

[its_anandrjs]

Then try this way

Left(YourField,4)&'/'&Right(YourField ,2)

But not in date format.

Hope this helps