Calculate a date range

October 28, 2014 19:03

Does anyone know how to make a calculation take a start date and subtract it from the present date to output total number of days? Essentially I have a membership list with a "join date" field and I want to be able to output how many days they've been a member to use for other analysis.

Thanks!

Comments

10 comments

tuck

March 09, 2015 02:40
+1
I really need this too.
0

Comment actions Permalink
Daniel Macedo

April 05, 2015 19:48
I'd like also!
0

Comment actions Permalink
Jan Richter

April 08, 2015 19:13
var d1 = moment(@Start);
var d2 = moment();
var result = d2.diff(d1, 'days');
result;

"@Start" should be replaced with your Start Date Field
1

Comment actions Permalink
Sam Brooks

April 08, 2015 19:19
This is fantastic, thank you!
1

Comment actions Permalink
Francisco Mendoza Garibay

August 26, 2015 18:40
Thank you!
0

Comment actions Permalink
Admin - BK

August 03, 2016 15:33
Dear Jan, whats wrong with my code?

Its not working.

Thanks for your help.
0

Comment actions Permalink
Jan Richter

August 04, 2016 10:43
Hej, look at the var d2. You have to set it. It is the ending date: moment(@enddate).
0

Comment actions Permalink
Admin - BK

August 04, 2016 12:34
nop. still same problem.

and also, in these case i dont think that we need a enddate?

"start date and subtract it from the present date to output total number of days?"
0

Comment actions Permalink
Jan Richter

August 04, 2016 12:45
Hej, calculation fields are stupid. If you have first just put in a date, the calculation field tries to give out the number as a date. But it can't cause it is a number. Just delete the calculation field, insert a new one, paste the skript and fill in date @A0. After that it should work.
0

Comment actions Permalink
Admin - BK

August 04, 2016 13:27
yes i relased that. its working now.

what a shame :p

thanks buddy.
0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?