# Apoc.date.parse not work in Neo4j Desktop for mac OS?

**URL:** <https://community.neo4j.com/t/apoc-date-parse-not-work-in-neo4j-desktop-for-mac-os/26516>\
**Category:** Procedures & APOC\
**Tags:** apoc\
**Created:** [October 3, 2020, 4:13am UTC](https://community.neo4j.com/t/apoc-date-parse-not-work-in-neo4j-desktop-for-mac-os/26516 "2020-10-03T04:13:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sen.zhang](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sen.zhang/32/3880_2.png) [@sen.zhang](https://community.neo4j.com/u/sen.zhang)\
**Post date:** [October 3, 2020, 4:13am UTC](https://community.neo4j.com/t/apoc-date-parse-not-work-in-neo4j-desktop-for-mac-os/26516/1 "2020-10-03T04:13:21Z")

</div>

I can execute the following command in neo4j Sandbox, neo4j desktop of Linux(ubuntu 18), but when I execute it in Neo4j desktop for mac OS

```auto
return apoc.date.parse('Jul 12, 2019', 's', 'MMM dd, yyyy')

```

I get the following error

```auto
Failed to invoke function `apoc.date.parse`: Caused by: java.text.ParseException: Unparseable date: "Jul 12, 2019"

```

I have tried this on server 4.1.1, 4.1.0, 4.1.2, 3.5.17, all of them not working.

My Neo4j Desktop is v1.3.8.

---

<div class="post-metadata">

**Author:** ![MuddyBootsCode](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/muddybootscode/32/10330_2.png) [@MuddyBootsCode](https://community.neo4j.com/u/MuddyBootsCode)\
**Post date:** [October 3, 2020, 10:11am UTC](https://community.neo4j.com/t/apoc-date-parse-not-work-in-neo4j-desktop-for-mac-os/26516/2 "2020-10-03T10:11:37Z")

</div>

Let me ask the "is the machine plugged in" question. Do you have APOC procedures installed on your instance? If not, you may not have access to them, as APOC isn't installed by default. In case it's not there you can follow these steps [Neo4j APOC Library - Developer Guides](https://neo4j.com/developer/neo4j-apoc/) to install it.

---

<div class="post-metadata">

**Author:** ![sen.zhang](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/sen.zhang/32/3880_2.png) [@sen.zhang](https://community.neo4j.com/u/sen.zhang)\
**Post date:** [October 3, 2020, 1:38pm UTC](https://community.neo4j.com/t/apoc-date-parse-not-work-in-neo4j-desktop-for-mac-os/26516/3 "2020-10-03T13:38:35Z")

</div>

Yes, I can run the function apoc.load.json in the same machine without any problem.

---

<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:** [October 4, 2020, 5:16am UTC](https://community.neo4j.com/t/apoc-date-parse-not-work-in-neo4j-desktop-for-mac-os/26516/4 "2020-10-04T05:16:58Z")

</div>

```auto
Try this:
RETURN apoc.date.format(apoc.date.parse('Jul 12, 2019', 'ms', 'MMM dd, yyyy'), 'ms', 'yyyy-MM-dd')

Result:
"2019-07-12"

```

---

<div class="post-metadata">

**Author:** ![patrick.jacquit](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/patrick.jacquit/32/8689_2.png) [@patrick.jacquit](https://community.neo4j.com/u/patrick.jacquit)\
**Post date:** [October 4, 2020, 1:21pm UTC](https://community.neo4j.com/t/apoc-date-parse-not-work-in-neo4j-desktop-for-mac-os/26516/5 "2020-10-04T13:21:09Z")

</div>

Hi Sen,

```
I reassure you, this problem occurs also in Neo4j aura. For the moment, i didn’t dive on this issue. I kept as à string for now the value. The alternative is to using substring. 

```

Br