Implement advanced filter where date after given date but before current date

Hi, I have my customer renewal data left joined with customer score data (score allocated based on many factors like installtion status, settings status etc.). Customer scores were allocated only si...