Convert dropdown text to number


I’ve been tinkering with the following for a while. I implemented three dropdowns for the user to select his/her birthday. See above image. Next to the dropdowns is a TEXT FIELD (“birth_date”) with dynamic data that collects the information from the dropdowns and displays it as a date/time. My problem is that I haven’t managed to convert the month’s dropdowns (abbreviated as “Jan.”, “Feb.”, etc.) to the corresponding numbers (“1”, “2”, etc.) in order for the TEXT FIELD to display the correct month.

Currently, the formula I’m using looks like this:

Screenshot 2021-04-02 at 15.39.17

Many thanks for your help,

And Happy Easter!


You can find and replace (Jan. = 1 = January).

But why are you not using the date & time picker? :slightly_smiling_face: :computer:

Dear hacker,

Thanks a lot. That worked :slight_smile:

I’m using dropdowns because it fits the UX and UI experience of the application, and because I was curious to see how far I can go with a custom solution.

1 Like