wants to store the first 1+dpd date, first 15+dpd date, first 30+dpd date for existing and upcoming records

I just wants to store the dates where loan goes to 1+dpd, 15+dpd, 30+dpd first ever.
I wants this for existing as well as upcoming loans.

image

Can you provide a small sample dataset instead of a screenshot? Also, an example of what you would expect the outcome to look like?