Calcul duration between 2 datesHello,
My name is Martin, I’m french, so would you please forgive my english.
I start jmp and I’m no talented with logiciels and computers, but I am motived to progress.
My question is simple :
How can I create a new variable « duration » (in month) between the difference of two variables (date begin/date end) in dd/mm/yy.
Thank you for your comprehension.
Sincerely,ScriptingRe: Calcul duration between 2 datesAssuming your "date begin" and "date end" columns are valid JMP Date/Time values, then the new formula for calculating the difference is
Date Difference( :date begin, :date end, "month" )
Here is an image of the attached example data table that has the date begin and date end columns and a new column, Difference that uses the above formula
If your date begin and date end are Character columns and not JMP Date/Time columns, you will need to convert them to Date/Time columns before being able to calculate the difference. This can be done easily and has been covered multiple times in previous Discussion entries.
Re: Calcul duration between 2 datesGood information about JMP date, time, datetime, and duration columns here:
Using dates, times, datetimes and durations in JMP
Re: Calcul duration between 2 datesThanks to you two.
I really appreciate your help.
I will try it.
Sincerely,
Re: Calcul duration between 2 datesHello txnelson,
I don't understand, I can not suceed.
Would you like to see my data table ?
Thank you.
Re: Calcul duration between 2 datesI suspect that my Example data table confused the issue. I have attached a new example data table. It has 2 columns which represent the beginning date(date de début) and the ending date(date de fin). I assume that you have a data table that has such columns. All that needs to be done, is to then add a new column which in the example data table is called "Columne 3", which is the column that takes the beginning date and ending date columns and finds the difference.
