Convert single select field to datetime_parse field

[Valida_Beckman]

Hi everyone,

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!
V

[Jason]

Hi @Valida_Beckman,

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!

[Valida_Beckman]

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?

Thanks!

[Valida_Beckman]

May I please have some help with accessing this link?

support.airtable.com

Airtable - Support

It does not work for me.
Is there any other way you can direct me to that support article?
Thanks again!

[Nathalie_Collin]

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.

[Valida_Beckman]

Thanks Nathalie – actually this has been an issue for the past week, since Sep 18 I think

[Jason]

@Valida_Beckman So sorry for not responding again! The article should be accessible now.

[Valida_Beckman]

No worries, I can access it now - will let you know if I have any more questions etc. Thanks!