Calculated column no longer valid when moved from dxp file to server

[Robert Eaton]

Hey All,

I have a calculated column using the following formula

DateDiff([One Year Forward From Date Approved],Today())

the data type is timespan of course and it works great on the .dxp file dashboard however I receive this error message when the dashboard is saved onto a server for sharing

The following columns are no longer valid: Days Until Renewal Due

Because of this I am left with a blank column and a visual which is not correct. Does anyone have any thoughts or solutions I am trying to find a solution not involving Iron Python or any other type of script if possible but will explore that if need be.

Thank you

[Fabian Duerr]

I'm curious. Which version of Spotfire are you using. I use 7.11 and there is no built-in Today() function.

[Kirsten Smith (she/her)]

Did you change the source of your data  Did it go from Imported to In-database  When dealing with in-db data not all Spotfire functions are available.

[Robert Eaton]

The formulas are in the database. fabd you have a great point i think the version is the problem. The .dxp file version is 10.4 but on the server it is version 7.11 and this creates the issue. Does anyone know how to fix that problem. I've already asked and am told our server is 10.4 but when the program saves it to the server it becomes 7.11