Hi, for your assistance please. How can I get the beginning month of the current year based on the a line item which is Month format from a line item data converted from a number format to a date format? I created a system module but I cannot use it or refer it because the data that I need to get should refer to the line item (Month). Please see ss of my modules below. Thank you.
Data Module
Solved! Go to Solution.
Try using the following
=PERIOD(START(Current Year Formatted Line Item))
The target line item should be month formatted.
This will return the first month of the year being queried.
You have all the information you need right there, but I would suggest the following:
Rob
Rob