# Convert timestamp with am/pm in field to date
**URL:** https://discuss.elastic.co/t/convert-timestamp-with-am-pm-in-field-to-date/147804
**Category:** Logstash
**Created:** [September 8, 2018, 9:43am UTC](https://discuss.elastic.co/t/convert-timestamp-with-am-pm-in-field-to-date/147804 "2018-09-08T09:43:05Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@sysdradmin](https://discuss.elastic.co/u/sysdradmin)
#### Post date: [September 8, 2018, 9:43am UTC](https://discuss.elastic.co/t/convert-timestamp-with-am-pm-in-field-to-date/147804/1 "2018-09-08T09:43:05Z")
Hello,
we have a field named 'timestamp' with the format : "12/09/2018 01:02:10 AM" or " 01/05/2018 05:04:01 PM"
how to convert it to date format ?
i don't know how to delete 'AM' or 'PM' to real time...
thks for help
rgds
---
### Author:  [@sysdradmin](https://discuss.elastic.co/u/sysdradmin)
#### Post date: [September 8, 2018, 9:59am UTC](https://discuss.elastic.co/t/convert-timestamp-with-am-pm-in-field-to-date/147804/2 "2018-09-08T09:59:13Z")
found ... need to add aa to match filter 😉
---
### Author:  [@sysdradmin](https://discuss.elastic.co/u/sysdradmin)
#### Post date: [September 8, 2018, 10:32am UTC](https://discuss.elastic.co/t/convert-timestamp-with-am-pm-in-field-to-date/147804/3 "2018-09-08T10:32:21Z")
but i only see am time not pm time
---
### Author:  [@sysdradmin](https://discuss.elastic.co/u/sysdradmin)
#### Post date: [September 8, 2018, 10:44am UTC](https://discuss.elastic.co/t/convert-timestamp-with-am-pm-in-field-to-date/147804/4 "2018-09-08T10:44:01Z")
found. prefer use hh instead of HH
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 6, 2018, 10:44am UTC](https://discuss.elastic.co/t/convert-timestamp-with-am-pm-in-field-to-date/147804/5 "2018-10-06T10:44:13Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.