I have a query where I have to fetch the data of casual labour workers in my company. I have already sorted and filtered their data using time data and and their active status.
Now i need to insert the date function in such a way that if this automail shoots itself on 1st of any month, the record of previous 15 days should be visible in that report, (i.e) Automail shoots on 1st January 2024 then the record displayed should be in between, from 16th December 2023 and 31st 2023. And if the automail shoots on 16th January 2024, then the data to be displayed should be in between 1st January 2024 to 15th January 2024.
Any suggestions for the same ?