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)?
Hi JennyMilf
You can refer to the following calculated column:
YearMonth_Date = CONVERT([Year-Month],DATETIME)
Month_num=MONTH(CONVERT([Month_hoa]&" "&"1",DATETIME))
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly