Spotfire Ideas Portal
DateDiff - function is used to find the ageing between start date and end date but it includes weekends.
Spotfire should add a new functionality in DateDiff function which accepts are parameter to exclude weekends and find working days ageing.
DateDiff('Workingdays',[Start Date],[End Date])
if this is not feasible then add new date function to find date difference for working days (Mon-Fri)
I know, we can write a calculated expression to achieve this. but default function will be added advantage to spotfire
The challange is to find a definition of working days that's applicable world wide.
Hi,
you can download the extension via exchange.ai
https://exchange.ai/downloads/datetimediff-calculation-method/
Thanks,
Michal
Hi Shanmugam,
we have this function implemented since ages (including "working time from", "working time to").
this is the description of the function:
Calculates the working time difference between two datetime values
(Saturdays and Sundays are excluded).
Arg.1 = FromDateTime,
Arg.2 = ToDateTime,
Arg.3= FromWorkingTime,
Arg.4 = ToWorkingTime.
Example: DateTimeDiffWork(DateTime(2012,11,19,8,0,0,0),DateTime(2012,11,26,22,30,0,0),Time(9,0,0,0),Time(17,30,0,0))
Output: 2.3:0:0.000
Let me know please if you are interested - michal.jakubik@miasolutions.sk
Michal