Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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 ❤️