MK

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

 

 

by Bernd Ziegler
Posted on Fri, 02/13/2015 - 10:58

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

 

0
by Mijo Kardum Author
Posted on Fri, 02/13/2015 - 11:04

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

 

 

 

0
by Éber Moreira
Posted on Wed, 02/18/2015 - 17:24

Hello Mijo,

There is my solution using oracle database.

Import the attachment file and configure the data source for oracle.

Best regards,

 

0
by Mijo Kardum Author
Posted on Fri, 02/20/2015 - 10:49

Thank you Eber,

I will try your solution.

BR,

Mijo

0

Featured achievement

Genius
You like to help others solve their problems by answering questions.
Recent Unlocks
  • KF
  • KH
  • RG
  • Profile picture for user Vee_ARIS
  • Profile picture for user smarty
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock