i have 2 date fields and want to be able to calculate the no months between the 2 dates - does any one have any sample code of ideas of how to achieve this?
Completely different approach. Add a meta data only field (derived field) and then use the base v[Enttity] to calculate the value on the fly by aliasing the caluatation to the meta data field. It falls down if there are any natural/direct table reads.
Example of derived field method (https://www.sagecity.com/sage-global-solutions/sage-crm/b/sage-crm-hints-tips-and-tricks/posts/adding-derived-fields-in-views-into-meta-data?CommentId=8476c5d9-de62-4174-bbc3-23bfa54afde3)
Another good option, Darren! This just adds to the concept that there's more than one way to accomplish the goal.