topic Re: Average Date Between Two Given dates in Talend Studio

Average Date Between Two Given dates

Anonymous — Fri, 12 Oct 2018 16:53:28 GMT

hello everyone,

in my scenario i want to find average date between gives two dates ,

Date 1 date 2

01-05-2002 03-09-2017

07-05-2001 05-02-2016

Thanks in advance,

Manish

Re: Average Date Between Two Given dates

vapukov — Sat, 13 Oct 2018 04:58:32 GMT

TalendDate.diffDate(myDate1,myDate2,"dd") - days between dates
Numeric.random(0,TalendDate.diffDate(myDate1,myDate2,"dd")) - random from 1 to number of day between dates
TalendDate.addDate(myDate1,Numeric.random(0,TalendDate.diffDate(myDate1,myDate2,"dd")),"dd") - add random days to begin date

so, final - TalendDate.addDate(myDate1,Numeric.random(0,TalendDate.diffDate(myDate1,myDate2,"dd")),"dd")

Upd

🙂 , never answer at night
sorry, read average as random, see answer from @tjclearner

Re: Average Date Between Two Given dates

tjohn — Sat, 13 Oct 2018 20:03:19 GMT

Hi,
- First calculate days between the 2 dates then divide by 2 : TalendDate.diffDate(Date2, Date1, "dd")/2
- Then add the result to Date1
----------
Thanks ,
tjclearner