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

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

Summary

Want to filter BICC extraction using 2 date columns

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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