Want first occurrence of relationship

[doshisheryansh9]

I have a data set where person name and place name is a node and they are connected with each other via datetime relationship when he was present there.

I want to see the first occurrence of the nodes and relationship

I am using distinct command but which is not providing me any result

MATCH n=(p:person)-[r:wasAt]->(s:station)
WHERE p.PERSON_NAME='Mark'
AND p.INFECTED_SINCE - duration ({minutes: 1260}) <= r.l_dt <= p.INFECTED_SINCE
RETURN n

[doshisheryansh9]

This gives me all the occurrence of relationship

[intouch_vivek]

@doshisheryansh93

Welcome to the community!!

Please revisit Neo4j temporal Date/time calculation and also you can use order by on Datetime to get the first occurrence