Month Year

[Gismo12]

Hi All,

 

Please could you assist? I want to select a date from the drop down calendar but only want to display Month and year

for example: April 2019

How do I accomplish this?

[rwoods]

Hello

The built-in drop down calendar can only display it's default view, that is selecting day/month/year. The idea is that it correctly populates a 'Date' field, which needs all three of those elements.

If you are just interested in Month and Year then presumably you are storing those in two separate fields? In which case, just use normal drop down list with value lists attached for months and years.

If you are trying to store the info in a date field, then you could use two fields as described above and use an auto enter calculation in your date field along the lines of :-

Date (monthField ; 1 ; yearField) 

to auto enter the 1st of the month and year as selected.

It hard too give you the best answer without a bit more information on what you are trying to do.

 

 

[comment]

"April 2019" is not a date, It's text. You cannot store it in a date field., and if you want a drop-down to show it, you need to define a value list for it. This won't be simple, because:

1. I presume you want the value list to show values that depend on the current date - but value lists require stored fields;
2. I presume you want the value list to show the values in chronological order - but value lists sort alphabetically.

There are workarounds for both problems, but it's not simple. 

 

Consider also other methods of selection, e.g. buttons in a popover.

 

 

 

 

Edited February 27, 2019 by comment