I have a use case where I need to find which month does a given date belong to.
Could you please help me
Thanks & Regards
Please use the time function 'PERIOD(Date formatted line item)'.
I hope this helps!!
To do this you need to use the formula PERIOD(x), where x is a date formatted line item.
The resulting line item needs to have the Month format.
I hope this helps.