TIBCO Spotfire FAQ

Can the DateDiff function in TIBCO Spotfire be used to compare months?

The DateDiff function does not compare the month. It currently only compares in day, hour, minute, second or millisecond.

To compare months one could instead e.g. use the Month function to extract the months from the dates (and if needed, the Year function to extract the year), and then subtract the results.

Published Sep 22 2009, 09:59 PM by spotfiresupport

Filed under: TIBCO Spotfire Professional, DateDiff

Comments

No Comments

This Blog

Training Classes

Syndication

Search TIBCO Spotfire FAQ

Spotfire's interactive information visualization and analytic solutions give users a remarkable experience for quickly and easily querying data and reporting results for superior business intelligence. From portfolio management and customer retention programs to key processes such as CRM, marketing, research, bioinformatics, yield and asset management and design for manufacturing, enterprises around the world rely on Spotfire's business analytics software to improve operational performance.