How to Group Dynamic Columns (date based)?

Uri_Teitler

We run a report every week to look for missing timesheets.

We need to group them by Prior Period and Current Period.

Then determine if there is any missing in those periods.

The report creates a new col each week (week beginning).

Once all missing timesheets are submitted the oldest dates drop off.

Attached is a sample of the input file and expected output file.

For this example I have assumed the "today's date" ie current period is 13/09/21 (DD/MM/YY)

Any help would be much appreciated.

Dynamic Cols with Dates.yxmd

atcodedog05

Hi @Uri_Teitler 

Here is how you can do it. It captures Latest 2 dates and sets it as current & prior.

Workflow:

Hope this helps : )

Dynamic Cols with Dates.yxmd