# Calculate number of days between two dates logstash \[solved\]

**URL:** https://discuss.elastic.co/t/calculate-number-of-days-between-two-dates-logstash-solved/96772
**Category:** Logstash
**Created:** [August 11, 2017, 12:21pm UTC](https://discuss.elastic.co/t/calculate-number-of-days-between-two-dates-logstash-solved/96772 "2017-08-11T12:21:27Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Chemse](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chemse/32/17956_2.png) [@Chemse](https://discuss.elastic.co/u/Chemse)
#### Post date: [August 11, 2017, 12:21pm UTC](https://discuss.elastic.co/t/calculate-number-of-days-between-two-dates-logstash-solved/96772/1 "2017-08-11T12:21:27Z")

</div>

Hello,

I want to calculate number of days between two dates in logstash  
I have :

```
date {
		match => ["Deb","dd/MM/YYYY"]
		target=> "Deb"
}
date {
	      match => ["toDay","dd/MM/YYYY"]
	      target=> "toDay"
}

```

and I did this Ruby filter but it doesn't work !!

```
ruby {
		init => "require 'time'"
		code => "event['duree'] = event['toDay'] - event['Deb'];"
}

```

Can you help me please 🙂

---

<div class="post-metadata">

### Author: ![Chemse](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chemse/32/17956_2.png) [@Chemse](https://discuss.elastic.co/u/Chemse)
#### Post date: [August 11, 2017, 1:07pm UTC](https://discuss.elastic.co/t/calculate-number-of-days-between-two-dates-logstash-solved/96772/2 "2017-08-11T13:07:22Z")

</div>

Solved by doing this

```
ruby {
	code => "event.set('duree', (event.get('toDay') - event.get('Deb'))/3600/24)"
}

```

first I got the period on secondes so I convert it to days

good luck 🙂

---

<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: [September 8, 2017, 1:07pm UTC](https://discuss.elastic.co/t/calculate-number-of-days-between-two-dates-logstash-solved/96772/3 "2017-09-08T13:07:51Z")

</div>

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