Deriving the current Month
We are using the line item 'Month' in one of the module, and the objective is to derive the current month so that we can capture the purchase trend of our hardwares.When I try to use the formula as Month= ITEM(Time), I am getting the error message as shown in the screenshot. I have also attached the settings of the Model calendar.
Also, we want the Month to display the month dynamically, i.e. In Dec '20 , it should show Dec-20 and Jan-21 in Jan'21 .
Any idea how to to achieve this functionality?