Skip to main content

Filter for showing products that fall in between a date

  • March 30, 2019
  • 2 replies
  • 38 views

Forum|alt.badge.img+5

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!

This topic has been closed for replies.

2 replies

Justin_Barrett
Forum|alt.badge.img+21

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.


Forum|alt.badge.img+5
  • Author
  • Participating Frequently
  • May 15, 2019

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!