# Convert 8 July 2013 to 7/8/2013

**URL:** <https://community.neo4j.com/t/convert-8-july-2013-to-7-8-2013/5626>\
**Category:** Cypher\
**Created:** [March 10, 2019, 5:21pm UTC](https://community.neo4j.com/t/convert-8-july-2013-to-7-8-2013/5626 "2019-03-10T17:21:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\
**Post date:** [March 10, 2019, 5:21pm UTC](https://community.neo4j.com/t/convert-8-july-2013-to-7-8-2013/5626/1 "2019-03-10T17:21:54Z")

</div>

I need to convert date 8 July 2013 to 7/8/2013 format. Any solution?

---

<div class="post-metadata">

**Author:** ![stefan.armbruster](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/stefan.armbruster/32/74_2.png) [@stefan.armbruster](https://community.neo4j.com/u/stefan.armbruster)\
**Post date:** [March 11, 2019, 12:22pm UTC](https://community.neo4j.com/t/convert-8-july-2013-to-7-8-2013/5626/2 "2019-03-11T12:22:48Z")

</div>

use `apoc.date.parse/format`.

---

<div class="post-metadata">

**Author:** ![andrew\_bowman](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/andrew_bowman/32/73_2.png) [@andrew\_bowman](https://community.neo4j.com/u/andrew_bowman)\
**Post date:** [March 11, 2019, 5:25pm UTC](https://community.neo4j.com/t/convert-8-july-2013-to-7-8-2013/5626/3 "2019-03-11T17:25:34Z")

</div>

More specifically the APOC function call would be:

```auto
return apoc.date.parse('8 July 2013', 'ms', 'dd MMMM yyyy')

```

---

<div class="post-metadata">

**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\
**Post date:** [March 11, 2019, 9:06pm UTC](https://community.neo4j.com/t/convert-8-july-2013-to-7-8-2013/5626/4 "2019-03-11T21:06:46Z")

</div>

Thanks Stefan and Andrew for the suggestions. This worked for me:

return apoc.date.format(apoc.date.parse('8 July 2013', 'ms', 'dd MMMM yyyy'), 'ms', 'MM/dd/yyyy')

Result: 07/08/2013