Hello MAshzone experts,
I would like to build Mashup which calculates the difference between 2 dates, without counting the week-end days in the result.
Is it possible to make something like that?
Best regards,
Mijo
4 Replies
-
Hello Mijo,
it is relatively easy to calculate the difference between 2 dates, you have only to convert this into milliseconds and then you can subtracting one date by the other. Now you have only convert milliseconds to seconds, hours or whatever you want.
But I don't know a way to do this without week-end days.
Best regards,
Bernd
-
Thaky you Bernd,
We know how to calculate timespan between 2 dates, but problem is when we need to do it without week-end days.
Any suggestion?
Best regards,
Mijo
-
Hello Mijo,
There is my solution using oracle database.
Import the attachment file and configure the data source for oracle.
Best regards,
-
Thank you Eber,
I will try your solution.
BR,
Mijo