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
jaweher899's avatar
jaweher899
Icon for Impactful Individual rankImpactful Individual
3 years ago

please try 

 

YearMonth_Date = DATE(
YEAR(DATEVALUE("01-" & RIGHT(Table[YearMonth], 2) & "-" & LEFT(Table[YearMonth], 4))),
MONTH(DATEVALUE("01-" & RIGHT(Table[YearMonth], 2) & "-" & LEFT(Table[YearMonth], 4))),
1
)