I have a use case where I need a to extract all records of current day and month over last 10 years. For example, today is 14th June 2021, so I need all records of a particular object from
- 14-6-2018 ...and so on.
The Date field that is to be used is Datetime field.
I have tried using the Calendar_MONTH & DAYS_IN_MONTH function, but I need to pass the value to these function dynamically. As of what I have tried, these function do not take reference value (such as integer ,string, date)