Returning results between 2 dates

[joao_marreiros0]

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 🙂

[ameyasoft]

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;

[stefan_armbrust]

Also note that Neo4j has native temporal types: https://www.adamcowley.co.uk/neo4j/temporal-native-dates/

[andrew_bowman]

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;

[joao_marreiros0]

Thanks all, and thanks for the link

[joao_marreiros0]

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

[ameyasoft]

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

[joao_marreiros0]

ameyasoft:

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

Thank you for your help