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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change date format

Hi,

When I upload my data through a qvd the date comes in the format mm\dd\yyyy in my chart

I need to get my date in the mmm - yy format

Please advise

Labels (1)
1 Solution

Accepted Solutions
fosuzuki
Luminary
Luminary

You can use the date() function:

date(YourFieldName, 'MMM-YY')

Hope this helps

Fernando

View solution in original post

2 Replies
fosuzuki
Luminary
Luminary

You can use the date() function:

date(YourFieldName, 'MMM-YY')

Hope this helps

Fernando

Not applicable
Author

Thank you so much. That worked perfectly