calculating numbers of days between 2 dates

mengkoon007
New Altair Community Member
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
Tagged:
0
Answers
-
Hi there,
time differences are always in ms. So you need to go for /1000/60/60/24 for days.
~Martin
0