Hi,
I have to categorize aging bucket based on the sales month
I have the sales month in the format of eg: 05/2020
Eg: This is the June month (06/2020). If the field contains 05/2020 it should be categorized as Current Month considering the current month
and if the month range as 04/2020 - 03/2020 then it should be 30-60 days
and if the month range as 02/2020 - 01/2020 then it should be 60-90 days and so on as shown in the below table.
05/2020 - Current Month |
04/2020 03/2020 - 30-60 Days |
02/2020 - 01/2020 - 60-90 Days |
Solved! Go to Solution.
Thank you so much for your help. This is what i was looking for