# Logstash deal with 24:00 time representation **URL:** \ **Category:** Logstash\ **Created:** [January 4, 2019, 7:40pm UTC](https://discuss.elastic.co/t/logstash-deal-with-24-00-time-representation/163007 "2019-01-04T19:40:32Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Joapfel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joapfel/32/39481_2.png) [@Joapfel](https://discuss.elastic.co/u/Joapfel)\ **Post date:** [January 4, 2019, 7:40pm UTC](https://discuss.elastic.co/t/logstash-deal-with-24-00-time-representation/163007/1 "2019-01-04T19:40:33Z")
Hello, I have a dataset containing a datetime representation like this **MM/01/yyyy 24:00** instead of **MM/02/yyyy 00:00** or **MM/01/yyyy 23:59** So the end of the day is represented as 24:00 and therefore not recognized by Elastcisearch/Kibana as the **@timestamp** (which is desired). How can I change it accordingly? Thanks in advance! ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [January 7, 2019, 9:44pm UTC](https://discuss.elastic.co/t/logstash-deal-with-24-00-time-representation/163007/2 "2019-01-07T21:44:19Z")
If you are parsing it with a date filter one option would be to mutate+gsub 24:00 to 23:59 before the date filter, and optionally use a ruby filter conditional upon the presense of 24:00 in the original field to add 60 seconds to the resulting date (using code similar to [this](https://discuss.elastic.co/t/convert-a-column-in-csv-to-hour-time/163098/2)). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 4, 2019, 9:44pm UTC](https://discuss.elastic.co/t/logstash-deal-with-24-00-time-representation/163007/3 "2019-02-04T21:44:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.