You gotta love TM1Web. I ran across an issue with dates and thought I’d pass it along in case anyone else runs into it. I created a form to create a loan record in TM1 and I needed to pass along several parameters from the form to a TI process, which included a couple of dates. These dates in TM1 are stored as serial numeric values. Starting in Perspectives, whenever the field that fed the parameter (via an action button) was formatted as date, the TI process would fail, saying that the parameter was not numeric (even though we all know that dates in Excel are actually numeric). So, I added a formula to the sheet that pointed to the cell containing the date and formatted that as numeric and passed that cell via the action button, instead of the actual cell containing the date. Voila, that worked.
I published the form to TM1Web and opened it up. I filled it out (entering a date like 12/31/2015) and posted. The TI now again reports the field not to be numeric, even though it worked in Perspectives. I tried every variation of Excel date format and no luck. If I entered a numeric value in the cell it would work but if I entered a date it would not (keeping in mind the cell that actually gets passed in the TI is just pointing to the cell containing the date AND the parameter cell is formatted as numeric). To make a long story short I found out that if instead of making the formula in the parameter cell just point to the date cell, like =A5, I make the formula =DATEVALUE(A5), then it works in both Perspectives and TM1Web. BTW, this is version 10.2.2 FP3.
Paid Advertisement:
