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: 
User5878
Contributor
Contributor
‎2021-07-21 11:16 AM

Covert from string to date format

I have a date in the format 'Aug 2020' and I'm trying to get Qlikview to recognize it as a date format instead of a string so that I can extract the individual elements such as the month and year but unfortunately nothing I've tried is working

1,221 Views
0 Likes
2 Replies
rwunderlich
MVP
MVP
‎2021-07-21 12:33 PM

Date(Date#(strdate, 'MMM YYYY'))

-Rob

1,178 Views
0 Likes
User5878
Contributor
Contributor
‎2021-07-28 03:48 PM
Author

Thanks!

1,147 Views