Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

ACC Function to use for "EFF_DT" of the total population count?


Level 2


I am setting up an Approval activity. I'm using a function to display the total population and the data schema, but I'd like to also use a function to give the approver the EFF_DT of the population. Effective date identifies which population of the table we are using.


Can this be done? What function could I use?



2 Replies


Community Advisor

Hi @JordanPhoenix ,


this question is unclear. What is exactly effective date of population? 

If you are making a counts of population per some date you can use MAX function but this is just a blind guess until you provide more information.






Hi @JordanPhoenix,

Were you able to resolve this query or do you need more help on this? Do let us know.


The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now