Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Feb 10, 2016
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
    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. 



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

Function to calculate the number of working weekdays

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 statement
over 8 years ago in Spotfire / Custom Expressions 1 Future Consideration