Sep 18, 2020 11:03 AM
What is the simplest way to convert a single-select field, which is the full word month (i.e., “January”), to a usable date field that provides the current MM/YYYY (i.e., “01/2020”)?
I’m integrating to Airtable from JotForm, and the field in Airtable has to match the format of the JotForm field. So my JotForm field is formatted as Dropdown, and my Airtable field (Field 16) is formatted as Single select.
My Airtable integration works for the Field 16, but I need a formula for my Activity Month field to convert that to MM/YYYY.
Thanks so much for your help!
Sep 18, 2020 11:11 AM
You’ll need to use the
DATETIME_PARSE formula to convert that to
MM/YYYY. We walk through some examples in this support article: https://support.airtable.com/hc/en-us/articles/360053626934.
Let me know if that helps!
Sep 18, 2020 12:18 PM
Sorry Jason, tried to access link but got a “403” - I’ve never logged into Zendesk before.
Any other way you can direct me to that support article?
Sep 23, 2020 09:10 AM
May I please have some help with accessing this link?
Sep 24, 2020 08:31 AM
Hi @Jason, Seems like there’s an issue internally today. All support articles are pointing to https://airtable.okta.com/login/login.html asking for a ZenDesk login credential.
CORRECTION - Seems to be just this article.
Sep 24, 2020 08:45 AM
Thanks Nathalie – actually this has been an issue for the past week, since Sep 18 I think
Sep 24, 2020 08:48 AM
Sep 24, 2020 08:53 AM
No worries, I can access it now - will let you know if I have any more questions etc. Thanks!