MO

Hi all,

I am working on Aris MashZone. Simple example to explain my problem.

Column A and Columnn B are Dates (Start date and End date)

Column C is a Text ( Comments)

I want to have in my output duration (difference) in days between date from Column B and Columnn A.  I was trying to use block Arithmetic but it requires a Number type not a Date type.

How can I do it?

Thanks in advance,

by Stephan Freudl
Posted on Fri, 10/21/2011 - 16:39

Hi,

you may convert your date columns into numbers to calculate durations as described for Andre.

 

Regards

Stephan

0
by Maciej Owczarek Author
Posted on Mon, 10/24/2011 - 08:09

Works great Thanks

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

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