Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Airtable AI
Airtable Enterprise Network
Marketing
Product Operations
EDUser Group
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
Yichi_Chen
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
Yichi_Chen - profile
Yichi_Chen
4 - Data Explorer
since
Sep 28, 2020
Nov 29, 2022
User Statistics
2
Posts
0
Solutions
1
Kudos given
0
Kudos received
User Activity
Posts
Replies
Convert a DATE string to a certain format
Sep 29, 2020
Hi All, I’m trying to use LEFT() to convert the following input: 2020-09-30T17:30:00-04:00 to 2020-09-30 Can anyone help me with it? Thank you.
Re: Convert a DATE string to a certain format
Sep 29, 2020
Hi Kuovonne, Thanks for helping me. This input is coming Calendly. How should I use DATETIME_PARSE and DATESTR()? Does it only capture the date and erase the other letters? If I understand right, PARSE is used to make all types into strings.
Kudos given to
User
Count
kuovonne
1
View all
