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
Could you give more of an explanation please? You already have activate date, then Year Month that i'm assuming comes from activate date. It look like you're trying to recreate activate date? I'm not sure what you're trying to do.
Could you give an example output. You may need to use CONVERT() to turn your string into a date format. Let me know and i'll get straight back to you 🙂 good luck