DESCRIPTION:

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 ( / ).

SYNTAX

yearmonth(‘Date Field’)

WHERE

  • 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

USAGE

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.

SEE ALSO

Revision: 2
Last modified: 2019/11/10

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment