Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Feb 10, 2016

RELATED IDEAS

Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit TS-I-5794 Way to calculate number of working week day.

Working Days function Merged

I would like to calculate the number of working days between two days in Spotfire DXP (create a new column with the number of working days, calculated from two other columns, which contain a start and end date).

  • Guest
    Reply
    |     Jun 3, 2016

    Probably something databases can easily do since most working days calculations will need to take into consideration regional calendars and local holidays which are not easy to keep updated. 

1 MERGED

Add NETWORKDAYS / WORKDAYS function

Merged
It would be great to have an OOTB solution to add a defined number of days to a given start date to create an end date, ignoring all weekend days.
almost 6 years ago in Spotfire / Custom Expressions 0 Future Consideration
1 MERGED

Function to calculate the number of working weekdays

Merged
Looking for a simple way to calculate the number of working weekdays. DateDiff("weekday",[ORDER DATE],[DELIVERY DATE]) In Spotfire, the closest I got is this reference page, with an absurdly long statementhttp://tibcoanalytics.com/spotfire/archive...
over 8 years ago in Spotfire / Custom Expressions 1 Future Consideration
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us