I've another problem. On the column A of my spreadsheet I have the Inicial Date values (Value in date format) and in the column B of my spreadhsheet I have the Final Date values (Value in date format) too.
I would like to calculate the difference between this 2 dates in a Text Object.
I tried to do the expression bellow, but it didn't work.
If you have one initial date and one final date selected =[Initial Date]-[Final Date] will return a value, but if you don't it won't return anything. If you have multiple dates selected (or nothing selected) you need to use dimensions so use a chart or use aggr in the text object (which isn't what you want in this case).
Also, I don't know what the quotes are for your text object... just do =[Initial Date]-[Final Date].
So you either need to use a chart with one of those dates as the dimension or select only one [Initial Date] and only one [Final Date] if you really want to put it in a text object (or you could use set analysis and variables but you didn't give any indication that that would solve your problem).
It´s not possible to see it in a text box at least you select only one record.
Do [Final Date]-[Initial Date] anywhere and you´ll have that difference in days. Check the script, it´s done there. Check the table, both are the same result. Before or after, but remember, in a text box: which record to operate or to show?
