This is very interesting. But I will need to run this in two steps, since the date prior the current date need to be negative and after positive.

How I can apply this to the whole table. This give me only the information between tow date, but I need to add a new column to my table that will host these values.

Thanks a lot