I need to find what the date is X% between two date fields. The use case is I want to send an email to someone who is 70% of the way through their tenancy.
Move-in date = 01/01/20 Move-out date = 31/01/20 Reminder date (70%) = 22/01/20
Is there a simple way to do this within one SQL? From what I've found so far, it's possible to find the percentage, but not the date it equates to.