Date dropdown of month and year

[Austin]

I need a drop down to just be Month,Year. The back end does not matter if it’s 3/1/20 or if its 3/20 or March 2020, etc; I just need the drop down to only have month year as options and I would like to keep it as one field.

[Steve]

help.appsheet.com

Dropdown from Valid_If

How to create a dropdown that depends on a particular list of values.

[Ahmed_Zeidan]

Dear Steve, can u explain in more details, basically we would like to have Jan 2020, Feb 2020, etc as drop down, I appreciate your advise if you have any suggestions around that

[rakhie_urs]

Create two different column having Enum as list of months Jan, Feb, Mar,...

And another column with enum as years 2001,2002,2003..( of your choice)

ADD another column(hidden) with expression Concatenate to combine above two columns' values

[OptimiX_XcrY]

Create a table with one column , enumerating month-years as text in desired format . With this table you create the valid if dropdown.

Depending on your needs (filter table , create rows, erc) In your main table , the one that contains dates, create a virtual column that extracts and transforms the dates in your text format . Use this VC for what you need

[shahappsheet]

Hi @OptimiX_XcrY !

.. enumerating month-years as text in desired format .

---

I couldn't understand this statement. Would you please explain the meaning of it for me. 🙏

Thanks.