Handling Datetime in Cypher for Neo4J?

Yes, Found it, datetime field need casting to filter the date or datetime Thanks

one thing i couldn't is to get the last 3 days, i have to check the t.TxnDateTime and the current datetime() difference of 3 days

As documented, comparisons can only be done between temporal instant values of the same type. For example, a date cannot be compared to a datetime, but it can be compared to another date.

Also, you can use an appropriate duration function (such as duration.inSeconds()) to subtract 2 temporal values, creating a duration. And you can then access a component of that duration using an appropriate property (such as seconds).

For example, this query:

WITH duration.inSeconds(
  date({year:2000, month:1, day:1}),
  date({year:2000, month:1, day:2})) AS durationInSeconds
RETURN durationInSeconds, durationInSeconds.seconds

returns:

╒═══════════════════╤═══════════════════════════╕
│"durationInSeconds"│"durationInSeconds.seconds"│
╞═══════════════════╪═══════════════════════════╡
│"P0M0DT86400S"     │86400                      │
└───────────────────┴───────────────────────────┘