Hi
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.
Another good option, Darren! This just adds to the concept that there's more than one way to accomplish the goal.
*Community Hub is the new name for Sage City