Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017compare function months spotfire tibco Used

0

Posted

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

1 Answer

0

Posted

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.