How to convert a date format [mm/DD/yy] to [yyyy/MM/dd] using APOC or Cypher

Hi Guys,

I have a CSV file where the date format is [mm/DD/yy] (for example: 7/13/19, "July 13, 2019") and I want to upload to Neo4j using [yyyy/MM/dd] (2019/13/07). Are there any APOC procedures or Cypher queries that I can use to do this?

Thank you

Sure, you can do a parse followed by a format with APOC:

WITH "07/13/19" as input
WITH, 'ms', 'MM/dd/yy') as ts
RETURN, 'ms', 'yyyy/MM/dd')
1 Like

RETURN"July 13, 2019", 'ms', 'MMMM dd, yyyy'), 'ms', 'yyyy/MM/dd')

Result: "2019/07/13"


Thank you guys the two answer are perfect. Both are really good solution.
Thank you so much

This was very helpful! Thank you so much!