# Date type column in Dataset (Spain) **URL:** \ **Category:** Ignition\ **Created:** [November 21, 2019, 11:42am UTC](https://forum.inductiveautomation.com/t/date-type-column-in-dataset-spain/30135 "2019-11-21T11:42:46Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [November 21, 2019, 11:42am UTC](https://forum.inductiveautomation.com/t/date-type-column-in-dataset-spain/30135/1 "2019-11-21T11:42:46Z")
Good morning. This problem is currently occurring in version **7.9.9** of Ignition with _ **Datasets** _ (_memory tag_) that have a column of type _ **Date** _ (it **only** happens with the _Date_ type, it does not happen for example with the _String_ type): First of all you have to create a _Dataset_ with a column of type _Date_ and apply the changes: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/ca98b4890767f8949d3b0bcc608f748fb875bee4.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/bdfcc32aa5282c7fa333166565e438dc9e14df5c.png) Next, one or more **rows** are added to the _Dataset_: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8068e730df39ff9cf943c2d60a8bce00bb9be61b.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/81e824494409eb05383878257d841ac5d50c976f.png) It seems that the rows are added without problems, but when applying the changes, the **rows and the column** of the _Dataset_ are **eliminated** , and this one takes the value **NULL** : ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/ca71d197fd09b37a1cfbc79ea67968dba217e500.png) I think the problem is related to the **date format**. Maybe, as I am in **Spain** there is an internal error of **incompatibility**. Best Regards. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [November 21, 2019, 12:35pm UTC](https://forum.inductiveautomation.com/t/date-type-column-in-dataset-spain/30135/2 "2019-11-21T12:35:09Z")
Did you try the date portion in ISO8610 format? `yyyy-mm-dd` ---
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [November 21, 2019, 12:45pm UTC](https://forum.inductiveautomation.com/t/date-type-column-in-dataset-spain/30135/3 "2019-11-21T12:45:37Z")
I have tried that and the problem continues. ---
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [November 25, 2019, 1:52pm UTC](https://forum.inductiveautomation.com/t/date-type-column-in-dataset-spain/30135/4 "2019-11-25T13:52:09Z")
Any help, please? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [November 25, 2019, 1:56pm UTC](https://forum.inductiveautomation.com/t/date-type-column-in-dataset-spain/30135/5 "2019-11-25T13:56:44Z")
IIRC, there was a bug in the tag editor making its dataset editor popup unreliable. I don’t recall what versions were affected. Try using a dataset property in a temporary window’s root container to compose your dataset, and place a button with a script that will write that dataset to the memory tag. ---
**Author:** ![informatica](https://avatars.discourse-cdn.com/v4/letter/i/3ab097/32.png) [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Post date:** [November 25, 2019, 6:27pm UTC](https://forum.inductiveautomation.com/t/date-type-column-in-dataset-spain/30135/6 "2019-11-25T18:27:19Z")
Ok. Thank you. I think it is fixed in Ignition 8.