I have imported data from gmail and it came under this date format in text. "Mon, 11 May 2020 14:31:44 -0500" and I need it in date format like this “5/11/2020”..
Can you suggest a solution for me ?
The DATETIME_PARSE function will only work if you are applying it to a text string that only has date information in it, such as what you posted in your initial post above: Mon, 11 May 2020 14:31:44 -0500
If you have a single “long text field” with a ton of data dumped into it that goes above & beyond the date information, it’s not going to work. You have to pull out the date separately first.