Year format conversion

[Anonymous]

Hi, can anyone tell me how to convert a year from YYYY to YY.

[ashfaq_haseeb · Accepted solution]

Hi,

Try

Right(Year,2) as NewYear

or

=date(today(),'YY')

regards

ASHFAQ

[avinashelite]

Hi,

Try like:

Date(Year(filed),'YY');

[Anonymous]

Thanks for the reply. It works

[ashfaq_haseeb]

welcome

Regards

ASHFAQ