Skip to main content

Qlik

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
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
‎2017-08-04 10:10 AM

Year with two digits?

Captura.PNG

Hi, could someone tell me how to put the year of the expressions with two digits?

I would like something like this: jul-16

Example of the name of one of my expressions:

=MonthName(vMaximaFechaMenosDoce)

The format of the varible is : yyyy-mm-dd


Many thanks!

1,785 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2017-08-04 10:20 AM

In response to Anil_Babu_Samineni

Or this

Date(MonthStart(FieldName), 'MMM-YY')

View solution in original post

1,681 Views
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-08-04 10:16 AM

May be this?

Date(VariableName,'MMM-YY')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
1,681 Views
sunny_talwar
MVP
MVP
‎2017-08-04 10:20 AM

In response to Anil_Babu_Samineni

Or this

Date(MonthStart(FieldName), 'MMM-YY')

1,682 Views