Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Convert single select field to datetime_parse field

Topic Labels: Formulas
557 7
Showing results for 
Search instead for 
Did you mean: 

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!

7 Replies 7

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:

Let me know if that helps!

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?

May I please have some help with accessing this link?

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

Hi @Jason, Seems like there’s an issue internally today. All support articles are pointing to asking for a ZenDesk login credential.

CORRECTION - Seems to be just this article.

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

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

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