Skip to main content

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:



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

Add two more filters based on your date fields:



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


Thanks Justin! That helps a lot!

Reply


Terms & Conditions