unfortunately I’m stuck at creating a date using three dropdown menus. My goal is to use three dropdowns (Month, Day, Year) to collect a date from the user. So far so good:
The problem starts with the month dropdown. I would like to create a dropdown in which the User can see the months (January, February etc.). I currently use an option set with all twelve months and the corresponding number behind it. (January → 01). As the Bubble formatting does not allow me to put in numbers that start with “0” as in the January case in a number field, I decided to go with a text field instead. All dropdown combined lead to a result such as 01032022 as a string (text) value.
My questions are:
How can I format this string of numbers into a date?
Is there any easier way to get my desired result without this big workaround?
I also thought about changing the dropdown attribute type of my option set to date, instead of string, but as it looks like, the database only allows me to put the values mm/dd/yyyy etc. at once into the attribute. (January → 01/03/2022 8:00 am) when I only would need the month.
Sorry for this long post. I hope someone can make sense of this problem. In the end, I just would like to create a date using the three dropdown menus.
Many thanks in advance for any hint on how to solve this!