Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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