Calculated column to subtract two dates

[Francisco Aspillaga]

Hi all,

My database is an Excel stored in Sharepoint. Within the columns there are two that are of the date type (Date2 and Date1), which formula could I use in a calculated column so that the result is expressed in numbers in Spotfire? If I do the subtraction Date2 - Date1 the result is shown in TimeSpam.

 

thanks!

[David Boot-Olazabal]

Hi Francisco,

You can use the Datediff() function, to calculate the number of days between to date columns (or if otherwise needed, you can return also the number of years, months, weeks).

The formula would look like this: DateDiff('day',[Date2],[Date1]).

 

Kind regards,

David