Filter BICC extraction based on Date Columns
Summary
Want to filter BICC extraction using 2 date columnsContent
In BICC extraction, need to apply a filter on 2 date columns for opportunity record. I have a scenario like, need to extract opportunity data which is created {or} updated in last 6 months
Example:
Opp A : created on 10-Jan-2021 & last updated on 10-Jan-2021
Opp B : created on 21-May-2020 & last updated on 5-Jan-2021
Opp C : Created on 14-May-2020 & last updated on 28-May-2020
Now in BICC extraction, Opp A & Opp B should be extracted because it's created date or last updated date with in a period of last 6 months timeframe. Since Opp C is not met that condition it should not be extracted in the BICC job.
0