Hi,
In the post
https://bobj-board.org/t/131902
Join the table with a Date_Generation Transform that has the entire start-end-date-range ever possible, e.g. starting 1900 until 2099.
The join-condition is
where startdate >= date_gen.date and enddate <= date_gen.date The join condition should be
date_gen.date >= startdate and date_gen.date <= enddate
Regards,
Sameer
sameer81 
(BOB member since 2007-09-15)