The yearmonth() function combines the results returned by the year() and month() functions in order to return a single value equal to the year (YYYY) and month (MM) of a date with the returned values separated by a slash ( / ).
- yearmonth is the function keyword. This must be entered into the Ninox function editor in all lower-case characters
- The YYYY segment of the value returned by the yearmonth() function is a four-digit value representing the year of the date that is the parameter to the function
- The MM segment of the value returned by the yearmonth() function is a two-digit value representing the month of the date that is the parameter to the function. Months are defined by numeric index where 1 = January, 2 = February, 3 = March, 4 = April, 5 = May, 6 = June, 7 = July, 8 = August, 9 = September, 10 = October, 11 = November, 12 = December.
Things to keep in mind when constructing this function:
- The results returned by the yearmonth() function is treated by Ninox as a text string. If you wish to return the month of a date and the year of a date as separate numeric values consider using the year() and month() functions separately
- Users can also use the format() function and the M parameters to that function to determine the month of a date
It is common for Ninox users to want to sort, analyze and report groups of records – arrays – based on the month and year of the record. Whether “month and year” refer to an invoice date, date of record entry, meeting date or the date when a specific item was purchased, the results of the yearmonth() function are particularly useful as sort and presentation criteria in views like Charts, Kanbans, Pivot Tables.