Confiforms: is there a way to return the last record for each month by filtering created filed?

[Pat L_]

I have a table with one record per day. For example

09-30-2022   data of 9/30/2022

09-29-2022   data of 9/29/2022

...

08-31-2022    data of 8/31/2022

08-30-2022    data of 8/30/2022

....

01-01-2022    data of 1/1/2022

Is there a way to return the last record for each month by filtering created filed? So the result will be like

09-2022    data of 9/30/2022

08-2022    data of 8/31/2022

....

By using tableview merger, I am able to return count, total, and average. For example:

Count:([count])

However, I would like to filter the month end data automatically. (one record per month)

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

You can use "Apply distinct filter to return only unique records" parameter with something like 

created.formatDate(MM-yyyy)

Alex

[Pat L_]

Awesome.

Thank you again, Alex.