Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Average Date Between Two Given dates

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

 

Labels (2)
2 Replies
vapukov
Master II
Master II

  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
Contributor
Contributor

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