Spotfire Ideas Portal
I need a year/month combination constantly for calculations like "get data between two months ago 1st of the month to the end of next month" Having either or both of these functions would make this task much easier. Yes, I can accomplish both today, but it takes a lot of work that is not intuitive to users who are not very good at building expressions. Trunc would be similar and just return the first of the month for the supplied date as a date format, whereas YearAndMonth would return an int.
If you have someone that codes in MS Visual studio, and access to the SDK, you could certainly build additional functions to add to the available functions. Our team has done a number of these custom & frequently used formulas like base M to N, day of Q, day of half, interval between two dates excluding weekends. etc.
Point is that the platform at least allows such additions to be added.