# Kibana: Can not load data **URL:** \ **Category:** Kibana\ **Created:** [December 14, 2020, 9:28am UTC](https://discuss.elastic.co/t/kibana-can-not-load-data/258554 "2020-12-14T09:28:42Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Phong\_Nguyen\_Dinh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/phong_nguyen_dinh/32/80798_2.png) [@Phong\_Nguyen\_Dinh](https://discuss.elastic.co/u/Phong_Nguyen_Dinh)\ **Post date:** [December 14, 2020, 9:28am UTC](https://discuss.elastic.co/t/kibana-can-not-load-data/258554/1 "2020-12-14T09:28:43Z")
I can not load the data in the Kibana table whenever my data contains a date format column ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/1/51b26e3ebc23f6c83692398c6d3be80007f857d9.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/f/8f9776baf8637d121d8a0e7d041cc0c3c51682cb.png) I'm using the latest version of ELK Please kindly help me to resolve this issue Thanks so much ---
**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\ **Post date:** [December 14, 2020, 11:28am UTC](https://discuss.elastic.co/t/kibana-can-not-load-data/258554/2 "2020-12-14T11:28:24Z")
Hi, could you provide some more info so that we can help you. Some things I'd be interested in: 1. What is the timerange you have selected? Are you sure there are documents in that timerange? 2. Can you paste the mapping for your index? 3. If you go to devtools and query the selected timerange, do you get any documents back? ---
**Author:** ![Phong\_Nguyen\_Dinh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/phong_nguyen_dinh/32/80798_2.png) [@Phong\_Nguyen\_Dinh](https://discuss.elastic.co/u/Phong_Nguyen_Dinh)\ **Post date:** [December 15, 2020, 1:54am UTC](https://discuss.elastic.co/t/kibana-can-not-load-data/258554/3 "2020-12-15T01:54:23Z")
Hi majagrubic 1. I chose time : last 1 year ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/b/fba2bc5f64508268f51f01d2c407230559fa62d9.png) 2. `index name: swap_comp_report , index pattern: swap_comp_report*` ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91fdc9a91d75125193b4630045826cdde565fbc2.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/e/fed35be3fc7903fb6a2335136aa472827edc569c.png) 3. ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/2/22162dd1fb8346890c62205ed3b398599d6e790f.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/a/8a06db84a6c80e039a79ed6be6bc17532b4fd33d.png) Seems I have a problem with the timestamp Thanks for your suggestion ---
**Author:** ![Phong\_Nguyen\_Dinh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/phong_nguyen_dinh/32/80798_2.png) [@Phong\_Nguyen\_Dinh](https://discuss.elastic.co/u/Phong_Nguyen_Dinh)\ **Post date:** [December 15, 2020, 2:38am UTC](https://discuss.elastic.co/t/kibana-can-not-load-data/258554/4 "2020-12-15T02:38:16Z")
Hi majagrubic, The problem was resolved. I tried to change the time range to 15 year ago But one more question For now, seems kibana creates timestamp by a date field in my csv data. How can I create the timestamp as current millisecond? Thank you so much ---
**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\ **Post date:** [December 16, 2020, 8:33am UTC](https://discuss.elastic.co/t/kibana-can-not-load-data/258554/5 "2020-12-16T08:33:40Z")
Glad it was resolved. You can create a [scripted field](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) that would get your date as milliseconds. The script would look something like: `doc['my_date_column'].date.getMillis()` ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 13, 2021, 8:33am UTC](https://discuss.elastic.co/t/kibana-can-not-load-data/258554/6 "2021-01-13T08:33:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.