Returns a number for each child record that indicates its recency. If a field is supplied then the records will be analysed after they have be sorted using this field.
RECENCY ( <table_name or field_name>, <link_table> [, <filter_query>] )
-
table_name or field_name: The name of the table at the many end of the link, or a field on this table. If a field is supplied then child records will be sorted using this field.
-
link_Table: The name of the parent table.
-
filter_query: A query string representing the domain of records to include.
Example: Create a field on the PRODUCT table that gives the recency of each record based on the value for products that were purchased in 1994.
RECENCY( [PRODUCT.PRODUCT_VALUE], CUSTOMER,[PRODUCT.PURCHASE YEAR] = "1994" )