# Power table column datatype change string to date

**URL:** <https://forum.inductiveautomation.com/t/power-table-column-datatype-change-string-to-date/44743>\
**Category:** Ignition\
**Created:** [March 22, 2021, 7:31am UTC](https://forum.inductiveautomation.com/t/power-table-column-datatype-change-string-to-date/44743 "2021-03-22T07:31:22Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![vasanth.p](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vasanth.p/32/38099_2.png) [@vasanth.p](https://forum.inductiveautomation.com/u/vasanth.p)\
**Post date:** [March 22, 2021, 11:22am UTC](https://forum.inductiveautomation.com/t/power-table-column-datatype-change-string-to-date/44743/2 "2021-03-22T11:22:28Z")

</div>

If you are intending to change the datatype of the specific column alone

> [@Illegal type for X value: class java.lang.String (column 'Date')](http://forum.inductiveautomation.com/t/illegal-type-for-x-value-class-java-lang-string-column-date/20124/2):
>
> You could use this code in a propertyChange script to convert your string to a date: from java.text import SimpleDateFormat # set the format of the date string format = SimpleDateFormat("MM/dd/yyyy") # get the raw data ds = event.source.parent.RawData # This is your memory tag in a CustomProperty ds2 = system.dataset.toPyDataSet(ds) newRows = [] if len(ds2) \> 0: # convert each row for row in ds2: dateStamp = format.parse(row[0]) newRows.append([dateStamp, row[1]]) # create the n…

Can help I guess..

---

_[View the full topic](https://forum.inductiveautomation.com/t/power-table-column-datatype-change-string-to-date/44743)._