The key expression in the formula is: {transaction.trandate} BETWEEN TRUNC(ADD_MONTHS({today},-11), ‘Month’) AND TRUNC(ADD_MONTHS({today}, 1), ‘Month’)-1 Allow me to break it down: (A) TRUNC(ADD_MONTHS({today},-11), ‘Month’) returns the 1st day of the month, 11 months ago from today. So if today is Feb. 14, 2024, it returns Mar. 1, 2023. (B) TRUNC(ADD_MONTHS({today}, 1), ‘Month’)-1 returns the last… Continue reading Dynamically get the last 12 months to date in Search