Forum Discussion
Convert text to Date
Hi everyone, How can I convert Year-month from text to Date? I tried: YearMonth_Date = DATE(LEFT(Table[YearMonth], 4), RIGHT(Table[YearMonth], 2), 1) but it's not work Thank you
How about Month_hoa convert to Date (just show month number)?
=SWITCH([Month Name],"Jan",1,"Feb",2,"Mar",3,"Apr",4,"May",5,"Jun",6,"Jul",7,"Aug",8,"Sep",9,"Oct",10,"Nov",11,"Dec",12,"Invalid Month")
Try this 🙂