How to change string in to datetime type?

Neo4j Graph Platform Import / Export
1

when i import CSV file into neo4j browser,there is a row called CreationDate. it has a different type of date format. so i use python to convert them into the same format. the python code is below:

image

however, i want this CreationDate data can be calculate in the neo4j, so when i import the final file into neo4j, use DateTime type but there always errors:

36

how can i change string type into DateTime type?
or how can i import appropriate format so that i can calculate easily

2

You don't need the brackets around {row.CreationDate}, as Cypher is interpreting this as a map literal, or as parameter access. Just use row.CreationDate without brackets.

3

What's worked for me is this:

datetime({epochMillis:apoc.date.parse(row['end date'],'ms', 'dd/MM/yyyy')})

Using a combination of the datetime() function and the apoc.date.parse() function.