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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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
‎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!

2,143 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

2,039 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
2,039 Views
sunny_talwar
MVP
MVP
‎2017-08-04 10:20 AM

In response to Anil_Babu_Samineni

Or this

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

2,040 Views