Forum Discussion

JennyMilf's avatar
JennyMilf
Icon for Helper I rankHelper I
3 years ago

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    
Need Help
JennyMilf's avatar
JennyMilf
Icon for Helper I rankHelper I
3 years ago

How about Month_hoa convert to Date (just show month number)?

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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