The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

calculating numbers of days between 2 dates

mengkoon007mengkoon007 Member Posts: 30 Contributor II
edited November 2018 in Help

Hi,

 

I am using the generate attribute with expression: date_diff(start_date,date_now()) to calculate the days from start date to current date. It shows "56473958106", may I know how to display in days? Thanks.

 

Start Date=3 Mar 2015

Current Date=15 Mar 2016

Numner of days=653 days

 

 

 

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist

    Hi there,

     

    time differences are always in ms. So you need to go for /1000/60/60/24 for days.

     

    ~Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.