How to use Time Period Format in a Date Formula
The date formula requires you to use numbers for the years, months, and days. I have 2 line items in a module that have the year, and a custom month list that contains the members of Jan, feb, mar, etc... For the month, I have a property on that list with the month number, so I can easily pull that into the date formula, but year cannot be pulled in. Trying to use year directly gets: "The 'year' argument for the 'DATE' function should have datatype of NUMBER not TIME PERIOD: DATE(year:NUMBER, month:NUMBER, day:NUMBER)" I can't convert it to text or a value or anything, so there is I don't see a way to populate the current period using a line item with a time period format. Has anyone run across this yet?