# Discover and transform don't show the same format on the same date field

**URL:** https://discuss.elastic.co/t/discover-and-transform-dont-show-the-same-format-on-the-same-date-field/290718
**Category:** Kibana
**Tags:** transforms
**Created:** [December 2, 2021, 1:18am UTC](https://discuss.elastic.co/t/discover-and-transform-dont-show-the-same-format-on-the-same-date-field/290718 "2021-12-02T01:18:54Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Liangliang\_Qiu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liangliang_qiu/32/78183_2.png) [@Liangliang\_Qiu](https://discuss.elastic.co/u/Liangliang_Qiu)
#### Post date: [December 2, 2021, 1:18am UTC](https://discuss.elastic.co/t/discover-and-transform-dont-show-the-same-format-on-the-same-date-field/290718/1 "2021-12-02T01:18:54Z")

</div>

When i discover the index pattern=shopee\_smart\_sorting\_my\_db\_\_address\_match\_result\_tab\*  
in Discover, it show the right format of "ctime" field

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/b/8bfd2780e6cf4f72625d839a31756e5e0adcd114.jpeg)

While when i use transform, it looks totally wrong,

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/8/68fea1799e4f2c7c4333889d98506ccc2b6b5f37.png)

What happened?

add one more point:  
when i use transform for index pattern, it shows the column in chart, but no value. Pretty strange!

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/c/fc5420628aba1331dd29ff719bf35f5636e07063.png)

---

<div class="post-metadata">

### Author: ![walterra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/walterra/32/139867_2.png) [@walterra](https://discuss.elastic.co/u/walterra)
#### Post date: [December 2, 2021, 2:14pm UTC](https://discuss.elastic.co/t/discover-and-transform-dont-show-the-same-format-on-the-same-date-field/290718/2 "2021-12-02T14:14:49Z")

</div>

Can you share the exact version you're using? We can then try to reproduce.

---

<div class="post-metadata">

### Author: ![Liangliang\_Qiu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liangliang_qiu/32/78183_2.png) [@Liangliang\_Qiu](https://discuss.elastic.co/u/Liangliang_Qiu)
#### Post date: [December 3, 2021, 1:22am UTC](https://discuss.elastic.co/t/discover-and-transform-dont-show-the-same-format-on-the-same-date-field/290718/3 "2021-12-03T01:22:42Z")

</div>

Kibana's version is v 7.9.2.

the type of ctime field is:  
"ctime": {  
"type": "date",  
"format": "epoch\_second"  
}

---

<div class="post-metadata">

### Author: ![walterra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/walterra/32/139867_2.png) [@walterra](https://discuss.elastic.co/u/walterra)
#### Post date: [December 27, 2021, 10:52am UTC](https://discuss.elastic.co/t/discover-and-transform-dont-show-the-same-format-on-the-same-date-field/290718/4 "2021-12-27T10:52:46Z")

</div>

I was able to reproduce your issue in `7.9.2`, the date field formatting for `epoch_second` is wrong in the Transforms UI. It looks like this was fixed in `7.10+` so upgrading should solve the problem for you.

I used these commands in Dev Console to verify:

```auto
PUT /test
{ "mappings": {"properties": {"post_date": {
    "type":"date",
    "format":"basic_date_time||epoch_second",
    "store":true
} } } } 

PUT /test/_doc/2
{
  "user" : "test1",
    "post_date" : "20150101T121030.000+01:00"
}

PUT /test/_doc/1
{
  "user" : "test2",
    "post_date" : 1521389162
}

GET test/_search 

```

Transforms UI `7.9.2`:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/8/086af5672e5bb54f81a553cf167d7aafceb7cb83.png)

Transforms UI `7.10.2`:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/c/9ce31599fc7a486db186783841b98febf1eb59a4.png)

Let us know if you get still empty cells in other columns after the upgrade. There were some related fixes in regards to nested field across some releases.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 24, 2022, 10:52am UTC](https://discuss.elastic.co/t/discover-and-transform-dont-show-the-same-format-on-the-same-date-field/290718/5 "2022-01-24T10:52:47Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.