Converting Mailchimp Date to an actual date
Hi. I have original data from Mailchimp for "Send Time" which is not formated as date, and has values like: "2019-05-05T13:24:46+00:00" I can't format this as a date, I get an #Error (it's currently text.) I have a new colum called Date Sent, which works with this formula: Date Sent = left('Campaign Summary'[send_time],10) which at least gets the relevant characters, which still can't be formatted as a date (#Error). I've tried changing the format in the "Modeling" tab. I've also tried doing a third column (I know this is silly) which would do this: format date sent = format('Campaign Summary'[Date Sent],"MM/YY") - which still returns only text. I only want this to customize my table for relative date filtering, which it can't do on text. Another option is to sort it by the text (which at least shows the most recent at the top), but then to limit the table to only the top ten records. Please let me know if there is a solution here. Thank you!