# Issue with Importing Date/Time in "MMM d, YYYY, HH:mm:ss tt" Format

**URL:** <https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653>\
**Category:** Issues\
**Tags:** imports\
**Created:** [August 11, 2025, 3:43pm UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653 "2025-08-11T15:43:51Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jake\_Webster](https://community.mycapitally.com/letter_avatar_proxy/v4/letter/j/db2777/32.png) [@Jake\_Webster](https://community.mycapitally.com/u/Jake_Webster)\
**Post date:** [August 11, 2025, 3:43pm UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/1 "2025-08-11T15:43:51Z")

</div>

Trying to import from Alpaca’s activities log via the clipboard, and am running into an issue with the date/time format.

E.g Input is Aug 11, 2025, 09:57:38 AM and get Aug 1, 2011, 8:00 PM as the imported date/time (The day from the input is used as the last two digits of the year on import, and the year gets dropped).

Could use help configuring the conversion, unless this is a bug.

---

<div class="post-metadata">

**Author:** ![rafal](https://community.mycapitally.com/user_avatar/community.mycapitally.com/rafal/32/18_2.png) [@rafal](https://community.mycapitally.com/u/rafal)\
**Post date:** [August 11, 2025, 4:22pm UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/2 "2025-08-11T16:22:40Z")

</div>

Hey Jake, looks like a bug - I’ll take a look and get back to you

---

<div class="post-metadata">

**Author:** ![rafal](https://community.mycapitally.com/user_avatar/community.mycapitally.com/rafal/32/18_2.png) [@rafal](https://community.mycapitally.com/u/rafal)\
**Post date:** [August 12, 2025, 8:06am UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/3 "2025-08-12T08:06:18Z")

</div>

The commas in the date where the cause of the issue. It will be fixed in the today’s update.

---

<div class="post-metadata">

**Author:** ![claudioivm](https://community.mycapitally.com/user_avatar/community.mycapitally.com/claudioivm/32/59_2.png) [@claudioivm](https://community.mycapitally.com/u/claudioivm)\
**Post date:** [September 3, 2025, 4:48am UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/4 "2025-09-03T04:48:45Z")

</div>

Hey Jake. How did you download all the activities from Alpaca? I can’t find an option for that. Thank you.

---

<div class="post-metadata">

**Author:** ![Jake\_Webster](https://community.mycapitally.com/letter_avatar_proxy/v4/letter/j/db2777/32.png) [@Jake\_Webster](https://community.mycapitally.com/u/Jake_Webster)\
**Post date:** [September 3, 2025, 11:33am UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/5 "2025-09-03T11:33:55Z")

</div>

Ah, I technically didn’t. I started by just Copy-pasting from the activities table. I plan to add a fetcher script to fetch the data through the Trader API and prepare a csv for capitally in the future.

---

<div class="post-metadata">

**Author:** ![claudioivm](https://community.mycapitally.com/user_avatar/community.mycapitally.com/claudioivm/32/59_2.png) [@claudioivm](https://community.mycapitally.com/u/claudioivm)\
**Post date:** [September 3, 2025, 3:03pm UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/6 "2025-09-03T15:03:54Z")

</div>

Oh I see. @rafal mate, any chance to do an integration or any workaround with Alpaca? It would help a lot [https://alpaca.markets/](https://alpaca.markets/)

Thank you.

---

<div class="post-metadata">

**Author:** ![rafal](https://community.mycapitally.com/user_avatar/community.mycapitally.com/rafal/32/18_2.png) [@rafal](https://community.mycapitally.com/u/rafal)\
**Post date:** [September 3, 2025, 3:52pm UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/7 "2025-09-03T15:52:18Z")

</div>

@claudioivm if it’s possible to copy a table and it contains relevant data, you can copy & paste into a spreadsheet (including the header) and send me a CSV to [support@mycapitally.com](mailto:support@mycapitally.com).

For example Finax does not allow customers to export the data, so this is how the importer is done (along with the instructions 😅).

---

<div class="post-metadata">

**Author:** ![claudioivm](https://community.mycapitally.com/user_avatar/community.mycapitally.com/claudioivm/32/59_2.png) [@claudioivm](https://community.mycapitally.com/u/claudioivm)\
**Post date:** [September 3, 2025, 4:41pm UTC](https://community.mycapitally.com/t/issue-with-importing-date-time-in-mmm-d-yyyy-hhss-tt-format/653/8 "2025-09-03T16:41:39Z")

</div>

> [@rafal](#):
>
> [support@mycapitally.com](mailto:support@mycapitally.com).

I used Table Capture chrome extension. CSV sent. Thanks mate.
