You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filter BICC extraction based on Date Columns

Accepted answer
edited Feb 2, 2021 10:09AM in Sales 4 comments


Want to filter BICC extraction using 2 date columns


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


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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!