Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
pratik_advani
Contributor
Contributor

Year format conversion

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

1 Solution

Accepted Solutions
ashfaq_haseeb

Hi,

Try

Right(Year,2) as NewYear

or

=date(today(),'YY')

regards

ASHFAQ

View solution in original post

4 Replies
ashfaq_haseeb

Hi,

Try

Right(Year,2) as NewYear

or

=date(today(),'YY')

regards

ASHFAQ

View solution in original post

avinashelite

Hi,

Try like:

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

pratik_advani
Contributor
Contributor
Author

Thanks for the reply. It works

ashfaq_haseeb

welcome

Regards

ASHFAQ