Average Date Between Two Given dates

[Anonymous]

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

[vapukov]

1. TalendDate.diffDate(myDate1,myDate2,"dd") - days between dates

2. Numeric.random(0,TalendDate.diffDate(myDate1,myDate2,"dd")) - random from 1 to number of day between dates

3. 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

[tjohn]

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