Returning results between 2 dates

Neo4j Graph Platform Cypher
1

Hi, I'm new in Neo4j, and I'm working and searching to learn more about it and graph usage.

I made this querry but it says that I have an error, anyone can help me so I can move on? What I want to know is what some user has bought between 2 dates (I used "EventDate" because its an existing property, with "date" it has the same result - error):

<
MATCH (ee:User) - [:Buy] - (Product)
WHERE ee.UserId = "u20784378"
WITH eventDate("2018-04-08") AS startDate, eventDate("2018-07-08") AS endDate
RETURN Product

Thanks :)

2

Try this:

Assuming eventDate is a property of Product

MATCH (ee:User) - [:Buy] - (p:Product)
WHERE ee.UserId = "u20784378"
AND p.eventDate >= "2018-04-08" AND p.eventDate <= "2018-07-08"
RETURN p;

3

Also note that Neo4j has native temporal types: An introduction to Temporal Date Types in Neo4j 3.4 - Adam Cowley | Full Stack Developer specialising in Neo4j and Node JS

4

Note also you can chain the inequalities:

MATCH (ee:User) - [:Buy] - (p:Product)
WHERE ee.UserId = "u20784378"
AND "2018-04-08" <= p.eventDate <= "2018-07-08"
RETURN p;
5

Thanks all, and thanks for the link

6

Tried, but eventDate is a property of a relationship between User and Product, in this case is "Buy". So it doesn't work :(

7

Try this:
MATCH (ee:User) - [r:Buy] - (p:Product)
WHERE ee.UserId = "u20784378"
AND "2018-04-08" <= r.eventDate <= "2018-07-08"
RETURN p;

8

Thank you for your help