Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

Convert Month Name to a Date

I'm sure that this really easy, but if I'm given a month name such as "February" in an excel file and need to convert it to a Date value such as 'MM/DD/YYYY', how would I do that?

1 Solution

Accepted Solutions
brf10043
Creator
Creator
Author

I just worked this out.  I discovered Date#

View solution in original post

2 Replies
brf10043
Creator
Creator
Author

I just worked this out.  I discovered Date#

Not applicable

is it just February or is it an entire date like Feb 03 2016

=date(date#('Feb 03 2016', 'MMM DD YYYY'), 'MM/DD/YYYY')