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

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.