# Toad is completely incapable of importing dates

**URL:** <https://forums.toadworld.com/t/toad-is-completely-incapable-of-importing-dates/37673>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 6, 2016, 6:36am UTC](https://forums.toadworld.com/t/toad-is-completely-incapable-of-importing-dates/37673 "2016-05-06T06:36:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![murray.wilson](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@murray.wilson](https://forums.toadworld.com/u/murray.wilson)\
**Post date:** [May 6, 2016, 6:36am UTC](https://forums.toadworld.com/t/toad-is-completely-incapable-of-importing-dates/37673/1 "2016-05-06T06:36:44Z")

</div>

I have tried to import a simple 1 row .csv file with a date in it (in mm/dd/yyy hh:mi:ss pm format) that I had previously exported from Toad.

I have attempted many times to change the custom date format to no avail. I have even tried removing the time and leaving just the date in the file (in mm/dd/yyyy format) and no matter what custom date format you choose Toad will _ALWAYS_ produce errors for the dates, even when the preview looks good.

I have come to the obvious conclusion that Toad is completely unable to import dates no matter what and wound up just having to type the values into the schema browser data grid ☹

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [May 6, 2016, 6:51am UTC](https://forums.toadworld.com/t/toad-is-completely-incapable-of-importing-dates/37673/2 "2016-05-06T06:51:14Z")

</div>

answered here

[www.toadworld.com/…/60526](http://www.toadworld.com/products/toad-for-oracle/f/10/p/23691/60526#60526)