May 11, 2020 01:22 PM
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 ?
May 11, 2020 01:29 PM
Welcome to the community!
In Airtable, you can create a formula field that uses the DATETIME_PARSE function to yield the result that you want.
Afterwards, you can change that formula field to a normal date field, and it will retain the data while giving you the date formatting that you’re looking for.
May 11, 2020 02:14 PM
Hello, Thanks a lot.
I get an error. The date is the header of a very long HTML format email that I am pulling in from gmail.
May 11, 2020 06:25 PM
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.
May 11, 2020 07:00 PM
Thanks a lot. I made it.