Filter for showing products that fall in between a date

Hi, wonderful community!

I have a subscription company that gives new toys to our customers every month. I’m trying to create a view that shows:

  • All the toys in stock
  • Toys that have not been given to this customer
  • Toys that are appropriate for her child

I’ve managed to do 1 & 2. Any ideas of how I can accomplish the third one?
I have got a field that shows for which Date of Birth this toy is suitable, start and end date.
I know the Date of Birth of the customers child, it needs to be between the start and end of the toy…

Thanks!

Add two more filters based on your date fields:

01%20PM

Enter the child’s birthdate into the filter fields, and it should narrow down the list of records.

2 Likes

Thanks Justin! That helps a lot!