Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Meshaikh1995
Contributor II
Contributor II

How to Convert Jan to 01, Feb to 02 so no.....

How to Convert Jan to 01, Feb to 02 so no.....

Labels (4)
1 Solution

Accepted Solutions
MayilVahanan

Hi

If its string and need to try get Number format, try like below

Date(Date#('Feb','MMM'),'MM')

Instead of Feb, change to ur field name

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi

If its string and need to try get Number format, try like below

Date(Date#('Feb','MMM'),'MM')

Instead of Feb, change to ur field name

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Meshaikh1995
Contributor II
Contributor II
Author

Thank You so Much ❤️