https://community.qlik.com/t5/QlikView/Find-date-in-range/m-p/2002822#M1221437 <P>Good Morning all,</P> <P>i have a list of dates (days with HH:MM:SS in num format) which cover a period of time in the past. The set is not a complete set of dates, <STRONG>there are gaps</STRONG>. I do now want to find the following three dates <STRONG>based on one selected date</STRONG>:</P> <UL> <LI>one week ago: same day in prior week. if that doesnt exist, then the first possible day before that day</LI> <LI>one month ago:&nbsp;same day in prior month. if that doesnt exist, then the first possible day before that day</LI> <LI>one year ago: same day in prior year. if that doesnt exist, then the first possible day before that day</LI> </UL> <P>I have attached the set of dates as a txt file to this post.</P> <P>Thanks for some support and advise upfront!</P> Thu, 10 Nov 2022 07:22:43 GMT xyz_1011 2022-11-10T07:22:43Z https://community.qlik.com/t5/QlikView/Find-date-in-range/m-p/2002822#M1221437 <P>Good Morning all,</P> <P>i have a list of dates (days with HH:MM:SS in num format) which cover a period of time in the past. The set is not a complete set of dates, <STRONG>there are gaps</STRONG>. I do now want to find the following three dates <STRONG>based on one selected date</STRONG>:</P> <UL> <LI>one week ago: same day in prior week. if that doesnt exist, then the first possible day before that day</LI> <LI>one month ago:&nbsp;same day in prior month. if that doesnt exist, then the first possible day before that day</LI> <LI>one year ago: same day in prior year. if that doesnt exist, then the first possible day before that day</LI> </UL> <P>I have attached the set of dates as a txt file to this post.</P> <P>Thanks for some support and advise upfront!</P> Thu, 10 Nov 2022 07:22:43 GMT https://community.qlik.com/t5/QlikView/Find-date-in-range/m-p/2002822#M1221437 xyz_1011 2022-11-10T07:22:43Z