How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific date

Summary:

Hi Community!

Hope to find you well.

Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective employee based on a specific date. The extraction, so, must be based on the employee's Effective Start Date.

I'm not so confident with the Dashboards, so i tried several times without succeeding.

Content (required):

Attached is:

• The Dashboard where the As of Date field must be active
• The Structure of the Dasboard page
• The Prompt of the Dashboard section
• The Analysis with the columns and filter

Thanks as always fot your attention and your time!