# How to convert nummeric values 201901020 into date 02.01.2019
**URL:** https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084
**Category:** Logstash
**Created:** [January 29, 2020, 10:52pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084 "2020-01-29T22:52:46Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Datakids](https://discuss.elastic.co/u/Datakids)
#### Post date: [January 29, 2020, 10:52pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/1 "2020-01-29T22:52:46Z")
Hi all,
I need your help with this case:
How can I convert fields containing values like 201901020 into date 02.01.2019
(the last zero of the value is useless but there)
I tried different mappings using follwoing simple but no success so far:
```
date {
match => ["FIELD_b", "WHATKINDOFMAPPING ?"]
target => "FIELD_c"
}
```
Thanks for your help
Brgds
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [January 30, 2020, 1:18am UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/2 "2020-01-30T01:18:17Z")
I haven't tested it, but "yyyyMMdd'0'" might work (not sure which way around month and day are where you live, so you might need to reverse them).
---
### Author:  [@Datakids](https://discuss.elastic.co/u/Datakids)
#### Post date: [January 30, 2020, 1:30pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/3 "2020-01-30T13:30:22Z")
Hi,
thanks for your reply.
No its not working!
I tried also to escape the ' and or in combination with ISO8601, UNIX, UNIX\_MS
Only if I use UNIX then I it'll mapped to a date field but with wrong Date!
Any suggestions?
---
### Author:  [@inhinyera16](https://discuss.elastic.co/u/inhinyera16)
#### Post date: [January 30, 2020, 1:54pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/4 "2020-01-30T13:54:49Z")
Here, you can try.
```
mutate {
#omit the last character
gsub => ["message", ".{1}$", ""]
}
date {
match => ["message", "yyyyMMdd"]
target => "FIELD_c"
}
```
you might specify the timezone if required.
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [January 30, 2020, 5:47pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/5 "2020-01-30T17:47:08Z")
> [@Datakids](#):
>
> No its not working!
OK, so how exactly does it not work. When I run
```
input { generator { count => 1 lines => [''] } }
filter {
mutate { add_field => { "FIELD_b" => "201901020" } }
date { match => ["FIELD_b", "yyyyMMdd'0'"] target => "FIELD_c" }
}
output { stdout { codec => rubydebug { metadata => false } } }
```
I get
```
"@timestamp" => 2020-01-30T17:45:53.334Z,
"sequence" => 0,
"FIELD_b" => "201901020",
"FIELD_c" => 2019-01-02T05:00:00.000Z
```
which surely appears to be working to me.
---
### Author:  [@Datakids](https://discuss.elastic.co/u/Datakids)
#### Post date: [January 31, 2020, 11:50pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/6 "2020-01-31T23:50:48Z")
yes, both works, I had to rechecked my config, thanks 🙂
```
{
"@version" => "1",
"FIELD_b" => "201901020",
"message" => "",
"@timestamp" => 2020-01-31T23:38:17.975Z,
"FIELD_c" => 2019-01-02T23:00:00.000Z,
"sequence" => 0
}
```
---
### Author:  [@Datakids](https://discuss.elastic.co/u/Datakids)
#### Post date: [January 31, 2020, 11:52pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/7 "2020-01-31T23:52:37Z")
Thanks for this solution =)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 28, 2020, 11:53pm UTC](https://discuss.elastic.co/t/how-to-convert-nummeric-values-201901020-into-date-02-01-2019/217084/8 "2020-02-28T23:53:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.