# Copying date from table

**URL:** <https://forum.inductiveautomation.com/t/copying-date-from-table/3158>\
**Category:** Ignition\
**Created:** [August 5, 2011, 1:53am UTC](https://forum.inductiveautomation.com/t/copying-date-from-table/3158 "2011-08-05T01:53:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![denji26](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/denji26/32/5805_2.png) [@denji26](https://forum.inductiveautomation.com/u/denji26)\
**Post date:** [August 5, 2011, 1:53am UTC](https://forum.inductiveautomation.com/t/copying-date-from-table/3158/1 "2011-08-05T01:53:20Z")

</div>

I have a table with a Date/Time column. Regardless of the Date Format I specify in the Table Customizer, if I copy and paste a date from a Date/Time cell, it appears in this format,

Sun Jul 31 08:10:00 MDT 2011

which is not recognizeable in excel as a date so my users are having issues doing whatever it is they want to do, most likely graph the data.

Is this a datetime format specified somewhere else that I can change? My next step is to write an export script but I thought I would see if anyone has any ideas first.

Thanks!

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [September 8, 2011, 4:11pm UTC](https://forum.inductiveautomation.com/t/copying-date-from-table/3158/2 "2011-09-08T16:11:32Z")

</div>

Just to clarify - you’re actually copying from the table using CTRL-C, not using an export function, correct?

If so, you’re right - the copy-to-clipboard mechanism isn’t correctly using the column’s dateformat. I’ll see what we can do about that.

---

<div class="post-metadata">

**Author:** ![denji26](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/denji26/32/5805_2.png) [@denji26](https://forum.inductiveautomation.com/u/denji26)\
**Post date:** [September 9, 2011, 3:44pm UTC](https://forum.inductiveautomation.com/t/copying-date-from-table/3158/3 "2011-09-09T15:44:39Z")

</div>

Correct, the client is just highlighting data he wants and using control-c to copy it out to excel. I was trying to write an event script for copying data to the clipboard but never managed to get it working properly.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [September 9, 2011, 5:25pm UTC](https://forum.inductiveautomation.com/t/copying-date-from-table/3158/4 "2011-09-09T17:25:22Z")

</div>

This was fixed, it’ll be in 7.3.