How to select last 5 days' records from each calendar month of given data set?

[shivakumarmanian]

Hi Team,

I have a bunch of sales records containing the sales dates.  I need to select all the records of last 5 days of each calendar month.  I would like to have the report saved in a file with Customer Name, Sale Date (only those records that are sold during the last 5 days of each calendar month).

Kindly help,

Thanks,

Siva

[Peachyco]

@TMHC : Here would be my approach to solving it:

This is what my input looks like:

This is the resulting dataset. You can just unselect the Grouping Date and the Record Count using the "Select" tool.

[TMHC]

Would you be able to provide the coding to be able to do this?

[Peachyco]

@TMHC : Here it is. Lemme know if it works for you. 😊

[Jay2022]

hi @grossal  I tried using this solution you provided but it is not working for my needs. Essentially I am trying to obtain data from the last 7 days only and weekly.