Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-09-23 03:09 AM

Year format conversion

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

Labels (1)
Labels
1,069 Views
0 Likes
1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III
‎2014-09-23 03:12 AM

Hi,

Try

Right(Year,2) as NewYear

or

=date(today(),'YY')

regards

ASHFAQ

View solution in original post

998 Views
0 Likes
4 Replies
ashfaq_haseeb
Champion III
Champion III
‎2014-09-23 03:12 AM

Hi,

Try

Right(Year,2) as NewYear

or

=date(today(),'YY')

regards

ASHFAQ

999 Views
0 Likes
avinashelite
MVP
MVP
‎2014-09-23 03:14 AM

Hi,

Try like:

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

998 Views
0 Likes
Anonymous
Not applicable
‎2014-09-23 04:05 AM
Author

Thanks for the reply. It works

998 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2014-09-23 04:07 AM

In response to Anonymous

welcome

Regards

ASHFAQ

998 Views
0 Likes